DBA Data[Home] [Help]

APPS.EGO_ICC_BULKLOAD_PVT dependencies on EGO_TRANS_ATTRS_VERS_INTF

Line 28: TYPE t_ta_intf_records IS TABLE OF ego_trans_attrs_vers_intf%ROWTYPE INDEX BY BINARY_INTEGER;

24: -- be used in TA comparison.
25: -- sreharih. Mon Apr 25 16:27:38 PDT 2011
26: --
27: TYPE t_ta_records IS TABLE OF ego_trans_attr_vers_b%ROWTYPE INDEX BY BINARY_INTEGER;
28: TYPE t_ta_intf_records IS TABLE OF ego_trans_attrs_vers_intf%ROWTYPE INDEX BY BINARY_INTEGER;
29:
30: -----------------------------------------------
31: --- This procedure prints the debugging information to a file or
32: --- to the concurrent program output

Line 7666: FROM ego_trans_attrs_vers_intf ta_int

7662: l_ret t_ta_intf_records;
7663:
7664: CURSOR c IS
7665: SELECT *
7666: FROM ego_trans_attrs_vers_intf ta_int
7667: WHERE ta_int.item_catalog_group_id = p_item_catalog_group_id
7668: AND ta_int.icc_version_number = p_version_seq_id
7669: AND ((ta_int.set_process_id IS NULL AND p_set_process_id IS NULL) OR
7670: (ta_int.set_process_id = p_set_process_id))

Line 7732: p_ta_intf_record IN ego_trans_attrs_vers_intf%ROWTYPE ) RETURN BOOLEAN IS

7728: --
7729: -- Check whether TA record matches to TA interface records
7730: --
7731: FUNCTION matches (p_ta_record IN ego_trans_attr_vers_b%ROWTYPE,
7732: p_ta_intf_record IN ego_trans_attrs_vers_intf%ROWTYPE ) RETURN BOOLEAN IS
7733:
7734: BEGIN
7735: IF p_ta_record.item_catalog_group_id = p_ta_intf_record.item_catalog_group_id AND
7736: p_ta_record.sequence = p_ta_intf_record.sequence AND