APPS.EGO_ICC_BULKLOAD_PVT dependencies on EGO_TRANS_ATTR_VERS_B

Line 27: TYPE t_ta_records IS TABLE OF ego_trans_attr_vers_b%ROWTYPE INDEX BY BINARY_INTEGER;

23: -- there are changes in TAs. Added below TYPE which will
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

Line 7637: FROM ego_trans_attr_vers_b ta

7633:
7634: l_ret t_ta_records;
7635: CURSOR c IS
7636: SELECT *
7637: FROM ego_trans_attr_vers_b ta
7638: WHERE ta.item_catalog_group_id = p_item_catalog_group_id
7639: AND ta.icc_version_number = p_version_seq_id
7640: AND ta.metadata_level = 'ICC'
7641: ORDER BY ta.sequence;

Line 7697: FROM ego_trans_attr_vers_b ta,

7693: l_ret fnd_descr_flex_column_usages.end_user_column_name%TYPE;
7694: l_proc_name CONSTANT VARCHAR2(30) := 'get_attr_internal_name';
7695: CURSOR c IS
7696: SELECT flex_col.end_user_column_name
7697: FROM ego_trans_attr_vers_b ta,
7698: ego_fnd_df_col_usgs_ext attr ,
7699: fnd_descr_flex_column_usages flex_col
7700: WHERE 1=1
7701: AND ta.item_catalog_group_id = p_item_catalog_group_id

Line 7731: FUNCTION matches (p_ta_record IN ego_trans_attr_vers_b%ROWTYPE,

7727:
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