APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on ICX_CAT_ITEMS_CTX_HDRS_TLP

Line 10: req_template_name icx_cat_items_ctx_hdrs_tlp.req_template_name%TYPE,

6: TYPE g_ctx_item_rec_type IS RECORD
7: (
8: inventory_item_id NUMBER,
9: po_line_id NUMBER,
10: req_template_name icx_cat_items_ctx_hdrs_tlp.req_template_name%TYPE,
11: req_template_line_num NUMBER,
12: org_id NUMBER,
13: language icx_cat_items_ctx_hdrs_tlp.language%TYPE,
14: source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,

Line 13: language icx_cat_items_ctx_hdrs_tlp.language%TYPE,

9: po_line_id NUMBER,
10: req_template_name icx_cat_items_ctx_hdrs_tlp.req_template_name%TYPE,
11: req_template_line_num NUMBER,
12: org_id NUMBER,
13: language icx_cat_items_ctx_hdrs_tlp.language%TYPE,
14: source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,
15: item_type icx_cat_items_ctx_hdrs_tlp.item_type%TYPE,
16: purchasing_org_id NUMBER,
17: owning_org_id NUMBER,

Line 14: source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,

10: req_template_name icx_cat_items_ctx_hdrs_tlp.req_template_name%TYPE,
11: req_template_line_num NUMBER,
12: org_id NUMBER,
13: language icx_cat_items_ctx_hdrs_tlp.language%TYPE,
14: source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,
15: item_type icx_cat_items_ctx_hdrs_tlp.item_type%TYPE,
16: purchasing_org_id NUMBER,
17: owning_org_id NUMBER,
18: po_category_id NUMBER,

Line 15: item_type icx_cat_items_ctx_hdrs_tlp.item_type%TYPE,

11: req_template_line_num NUMBER,
12: org_id NUMBER,
13: language icx_cat_items_ctx_hdrs_tlp.language%TYPE,
14: source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,
15: item_type icx_cat_items_ctx_hdrs_tlp.item_type%TYPE,
16: purchasing_org_id NUMBER,
17: owning_org_id NUMBER,
18: po_category_id NUMBER,
19: supplier_id NUMBER,

Line 20: supplier_part_num icx_cat_items_ctx_hdrs_tlp.supplier_part_num%TYPE,

16: purchasing_org_id NUMBER,
17: owning_org_id NUMBER,
18: po_category_id NUMBER,
19: supplier_id NUMBER,
20: supplier_part_num icx_cat_items_ctx_hdrs_tlp.supplier_part_num%TYPE,
21: supplier_part_auxid icx_cat_items_ctx_hdrs_tlp.supplier_part_auxid%TYPE,
22: supplier_site_id NUMBER,
23: status NUMBER,
24: ip_category_id NUMBER,

Line 21: supplier_part_auxid icx_cat_items_ctx_hdrs_tlp.supplier_part_auxid%TYPE,

17: owning_org_id NUMBER,
18: po_category_id NUMBER,
19: supplier_id NUMBER,
20: supplier_part_num icx_cat_items_ctx_hdrs_tlp.supplier_part_num%TYPE,
21: supplier_part_auxid icx_cat_items_ctx_hdrs_tlp.supplier_part_auxid%TYPE,
22: supplier_site_id NUMBER,
23: status NUMBER,
24: ip_category_id NUMBER,
25: ip_category_name icx_cat_categories_tl.category_name%TYPE,

Line 27: item_revision icx_cat_items_ctx_hdrs_tlp.item_revision%TYPE,

23: status NUMBER,
24: ip_category_id NUMBER,
25: ip_category_name icx_cat_categories_tl.category_name%TYPE,
26: req_template_po_line_id NUMBER,
27: item_revision icx_cat_items_ctx_hdrs_tlp.item_revision%TYPE,
28: po_header_id NUMBER,
29: document_number icx_cat_items_ctx_hdrs_tlp.document_number%TYPE,
30: line_num NUMBER,
31: allow_price_override_flag icx_cat_items_ctx_hdrs_tlp.allow_price_override_flag%TYPE,

Line 29: document_number icx_cat_items_ctx_hdrs_tlp.document_number%TYPE,

25: ip_category_name icx_cat_categories_tl.category_name%TYPE,
26: req_template_po_line_id NUMBER,
27: item_revision icx_cat_items_ctx_hdrs_tlp.item_revision%TYPE,
28: po_header_id NUMBER,
29: document_number icx_cat_items_ctx_hdrs_tlp.document_number%TYPE,
30: line_num NUMBER,
31: allow_price_override_flag icx_cat_items_ctx_hdrs_tlp.allow_price_override_flag%TYPE,
32: not_to_exceed_price NUMBER,
33: line_type_id NUMBER,

Line 31: allow_price_override_flag icx_cat_items_ctx_hdrs_tlp.allow_price_override_flag%TYPE,

27: item_revision icx_cat_items_ctx_hdrs_tlp.item_revision%TYPE,
28: po_header_id NUMBER,
29: document_number icx_cat_items_ctx_hdrs_tlp.document_number%TYPE,
30: line_num NUMBER,
31: allow_price_override_flag icx_cat_items_ctx_hdrs_tlp.allow_price_override_flag%TYPE,
32: not_to_exceed_price NUMBER,
33: line_type_id NUMBER,
34: unit_meas_lookup_code icx_cat_items_ctx_hdrs_tlp.unit_meas_lookup_code%TYPE,
35: suggested_quantity NUMBER,

Line 34: unit_meas_lookup_code icx_cat_items_ctx_hdrs_tlp.unit_meas_lookup_code%TYPE,

30: line_num NUMBER,
31: allow_price_override_flag icx_cat_items_ctx_hdrs_tlp.allow_price_override_flag%TYPE,
32: not_to_exceed_price NUMBER,
33: line_type_id NUMBER,
34: unit_meas_lookup_code icx_cat_items_ctx_hdrs_tlp.unit_meas_lookup_code%TYPE,
35: suggested_quantity NUMBER,
36: unit_price NUMBER,
37: amount NUMBER,
38: currency_code icx_cat_items_ctx_hdrs_tlp.currency_code%TYPE,

Line 38: currency_code icx_cat_items_ctx_hdrs_tlp.currency_code%TYPE,

34: unit_meas_lookup_code icx_cat_items_ctx_hdrs_tlp.unit_meas_lookup_code%TYPE,
35: suggested_quantity NUMBER,
36: unit_price NUMBER,
37: amount NUMBER,
38: currency_code icx_cat_items_ctx_hdrs_tlp.currency_code%TYPE,
39: rate_type icx_cat_items_ctx_hdrs_tlp.rate_type%TYPE,
40: rate_date DATE,
41: rate NUMBER,
42: buyer_id NUMBER,

Line 39: rate_type icx_cat_items_ctx_hdrs_tlp.rate_type%TYPE,

35: suggested_quantity NUMBER,
36: unit_price NUMBER,
37: amount NUMBER,
38: currency_code icx_cat_items_ctx_hdrs_tlp.currency_code%TYPE,
39: rate_type icx_cat_items_ctx_hdrs_tlp.rate_type%TYPE,
40: rate_date DATE,
41: rate NUMBER,
42: buyer_id NUMBER,
43: supplier_contact_id NUMBER,

Line 44: rfq_required_flag icx_cat_items_ctx_hdrs_tlp.rfq_required_flag%TYPE,

40: rate_date DATE,
41: rate NUMBER,
42: buyer_id NUMBER,
43: supplier_contact_id NUMBER,
44: rfq_required_flag icx_cat_items_ctx_hdrs_tlp.rfq_required_flag%TYPE,
45: negotiated_by_preparer_flag icx_cat_items_ctx_hdrs_tlp.negotiated_by_preparer_flag%TYPE,
46: description icx_cat_items_ctx_hdrs_tlp.description%TYPE,
47: long_description po_attribute_values_tlp.long_description%TYPE,
48: organization_id NUMBER,

Line 45: negotiated_by_preparer_flag icx_cat_items_ctx_hdrs_tlp.negotiated_by_preparer_flag%TYPE,

41: rate NUMBER,
42: buyer_id NUMBER,
43: supplier_contact_id NUMBER,
44: rfq_required_flag icx_cat_items_ctx_hdrs_tlp.rfq_required_flag%TYPE,
45: negotiated_by_preparer_flag icx_cat_items_ctx_hdrs_tlp.negotiated_by_preparer_flag%TYPE,
46: description icx_cat_items_ctx_hdrs_tlp.description%TYPE,
47: long_description po_attribute_values_tlp.long_description%TYPE,
48: organization_id NUMBER,
49: master_organization_id NUMBER,

Line 46: description icx_cat_items_ctx_hdrs_tlp.description%TYPE,

42: buyer_id NUMBER,
43: supplier_contact_id NUMBER,
44: rfq_required_flag icx_cat_items_ctx_hdrs_tlp.rfq_required_flag%TYPE,
45: negotiated_by_preparer_flag icx_cat_items_ctx_hdrs_tlp.negotiated_by_preparer_flag%TYPE,
46: description icx_cat_items_ctx_hdrs_tlp.description%TYPE,
47: long_description po_attribute_values_tlp.long_description%TYPE,
48: organization_id NUMBER,
49: master_organization_id NUMBER,
50: order_type_lookup_code icx_cat_items_ctx_hdrs_tlp.order_type_lookup_code%TYPE,

Line 50: order_type_lookup_code icx_cat_items_ctx_hdrs_tlp.order_type_lookup_code%TYPE,

46: description icx_cat_items_ctx_hdrs_tlp.description%TYPE,
47: long_description po_attribute_values_tlp.long_description%TYPE,
48: organization_id NUMBER,
49: master_organization_id NUMBER,
50: order_type_lookup_code icx_cat_items_ctx_hdrs_tlp.order_type_lookup_code%TYPE,
51: supplier icx_cat_items_ctx_hdrs_tlp.supplier%TYPE,
52: global_agreement_flag icx_cat_items_ctx_hdrs_tlp.global_agreement_flag%TYPE,
53: merged_source_type icx_cat_items_ctx_hdrs_tlp.merged_source_type%TYPE,
54: ctx_inventory_item_id NUMBER,

Line 51: supplier icx_cat_items_ctx_hdrs_tlp.supplier%TYPE,

47: long_description po_attribute_values_tlp.long_description%TYPE,
48: organization_id NUMBER,
49: master_organization_id NUMBER,
50: order_type_lookup_code icx_cat_items_ctx_hdrs_tlp.order_type_lookup_code%TYPE,
51: supplier icx_cat_items_ctx_hdrs_tlp.supplier%TYPE,
52: global_agreement_flag icx_cat_items_ctx_hdrs_tlp.global_agreement_flag%TYPE,
53: merged_source_type icx_cat_items_ctx_hdrs_tlp.merged_source_type%TYPE,
54: ctx_inventory_item_id NUMBER,
55: ctx_source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,

Line 52: global_agreement_flag icx_cat_items_ctx_hdrs_tlp.global_agreement_flag%TYPE,

48: organization_id NUMBER,
49: master_organization_id NUMBER,
50: order_type_lookup_code icx_cat_items_ctx_hdrs_tlp.order_type_lookup_code%TYPE,
51: supplier icx_cat_items_ctx_hdrs_tlp.supplier%TYPE,
52: global_agreement_flag icx_cat_items_ctx_hdrs_tlp.global_agreement_flag%TYPE,
53: merged_source_type icx_cat_items_ctx_hdrs_tlp.merged_source_type%TYPE,
54: ctx_inventory_item_id NUMBER,
55: ctx_source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,
56: ctx_item_type icx_cat_items_ctx_hdrs_tlp.item_type%TYPE,

Line 53: merged_source_type icx_cat_items_ctx_hdrs_tlp.merged_source_type%TYPE,

49: master_organization_id NUMBER,
50: order_type_lookup_code icx_cat_items_ctx_hdrs_tlp.order_type_lookup_code%TYPE,
51: supplier icx_cat_items_ctx_hdrs_tlp.supplier%TYPE,
52: global_agreement_flag icx_cat_items_ctx_hdrs_tlp.global_agreement_flag%TYPE,
53: merged_source_type icx_cat_items_ctx_hdrs_tlp.merged_source_type%TYPE,
54: ctx_inventory_item_id NUMBER,
55: ctx_source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,
56: ctx_item_type icx_cat_items_ctx_hdrs_tlp.item_type%TYPE,
57: ctx_purchasing_org_id NUMBER,

Line 55: ctx_source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,

51: supplier icx_cat_items_ctx_hdrs_tlp.supplier%TYPE,
52: global_agreement_flag icx_cat_items_ctx_hdrs_tlp.global_agreement_flag%TYPE,
53: merged_source_type icx_cat_items_ctx_hdrs_tlp.merged_source_type%TYPE,
54: ctx_inventory_item_id NUMBER,
55: ctx_source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,
56: ctx_item_type icx_cat_items_ctx_hdrs_tlp.item_type%TYPE,
57: ctx_purchasing_org_id NUMBER,
58: ctx_supplier_id NUMBER,
59: ctx_supplier_site_id NUMBER,

Line 56: ctx_item_type icx_cat_items_ctx_hdrs_tlp.item_type%TYPE,

52: global_agreement_flag icx_cat_items_ctx_hdrs_tlp.global_agreement_flag%TYPE,
53: merged_source_type icx_cat_items_ctx_hdrs_tlp.merged_source_type%TYPE,
54: ctx_inventory_item_id NUMBER,
55: ctx_source_type icx_cat_items_ctx_hdrs_tlp.source_type%TYPE,
56: ctx_item_type icx_cat_items_ctx_hdrs_tlp.item_type%TYPE,
57: ctx_purchasing_org_id NUMBER,
58: ctx_supplier_id NUMBER,
59: ctx_supplier_site_id NUMBER,
60: ctx_supplier_part_num icx_cat_items_ctx_hdrs_tlp.supplier_part_num%TYPE,

Line 60: ctx_supplier_part_num icx_cat_items_ctx_hdrs_tlp.supplier_part_num%TYPE,

56: ctx_item_type icx_cat_items_ctx_hdrs_tlp.item_type%TYPE,
57: ctx_purchasing_org_id NUMBER,
58: ctx_supplier_id NUMBER,
59: ctx_supplier_site_id NUMBER,
60: ctx_supplier_part_num icx_cat_items_ctx_hdrs_tlp.supplier_part_num%TYPE,
61: ctx_supplier_part_auxid icx_cat_items_ctx_hdrs_tlp.supplier_part_auxid%TYPE,
62: ctx_ip_category_id NUMBER,
63: ctx_po_category_id NUMBER,
64: ctx_item_revision icx_cat_items_ctx_hdrs_tlp.item_revision%TYPE,

Line 61: ctx_supplier_part_auxid icx_cat_items_ctx_hdrs_tlp.supplier_part_auxid%TYPE,

57: ctx_purchasing_org_id NUMBER,
58: ctx_supplier_id NUMBER,
59: ctx_supplier_site_id NUMBER,
60: ctx_supplier_part_num icx_cat_items_ctx_hdrs_tlp.supplier_part_num%TYPE,
61: ctx_supplier_part_auxid icx_cat_items_ctx_hdrs_tlp.supplier_part_auxid%TYPE,
62: ctx_ip_category_id NUMBER,
63: ctx_po_category_id NUMBER,
64: ctx_item_revision icx_cat_items_ctx_hdrs_tlp.item_revision%TYPE,
65: ctx_rowid VARCHAR2(50)

Line 64: ctx_item_revision icx_cat_items_ctx_hdrs_tlp.item_revision%TYPE,

60: ctx_supplier_part_num icx_cat_items_ctx_hdrs_tlp.supplier_part_num%TYPE,
61: ctx_supplier_part_auxid icx_cat_items_ctx_hdrs_tlp.supplier_part_auxid%TYPE,
62: ctx_ip_category_id NUMBER,
63: ctx_po_category_id NUMBER,
64: ctx_item_revision icx_cat_items_ctx_hdrs_tlp.item_revision%TYPE,
65: ctx_rowid VARCHAR2(50)
66: );
67:
68: TYPE g_bpa_online_flag_rec_type IS RECORD