APPS.IGR_INFTYP_PKG_IT_CRM_PKG dependencies on AMS_DELIV_KIT_ITEMS

Line 50: CURSOR c IS SELECT object_version_number,deliverable_kit_id from AMS_DELIV_KIT_ITEMS

46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48: x_deliverable_kit_item_id IN NUMBER
49: ) AS
50: CURSOR c IS SELECT object_version_number,deliverable_kit_id from AMS_DELIV_KIT_ITEMS
51: WHERE deliverable_kit_item_id = x_deliverable_kit_item_id;
52:
53: l_object_version_number AMS_DELIV_KIT_ITEMS.object_version_number%TYPE;
54: l_tmp_var VARCHAR2(2000);

Line 53: l_object_version_number AMS_DELIV_KIT_ITEMS.object_version_number%TYPE;

49: ) AS
50: CURSOR c IS SELECT object_version_number,deliverable_kit_id from AMS_DELIV_KIT_ITEMS
51: WHERE deliverable_kit_item_id = x_deliverable_kit_item_id;
52:
53: l_object_version_number AMS_DELIV_KIT_ITEMS.object_version_number%TYPE;
54: l_tmp_var VARCHAR2(2000);
55: l_info_type_id ams_deliv_kit_items.deliverable_kit_id%TYPE;
56: l_var NUMBER(10);
57: l_row_id VARCHAR2(25);

Line 55: l_info_type_id ams_deliv_kit_items.deliverable_kit_id%TYPE;

51: WHERE deliverable_kit_item_id = x_deliverable_kit_item_id;
52:
53: l_object_version_number AMS_DELIV_KIT_ITEMS.object_version_number%TYPE;
54: l_tmp_var VARCHAR2(2000);
55: l_info_type_id ams_deliv_kit_items.deliverable_kit_id%TYPE;
56: l_var NUMBER(10);
57: l_row_id VARCHAR2(25);
58:
59: CURSOR c_package_items( l_info_type_id igr_i_ityp_pkgs_v.info_type_id%TYPE ) IS