APPS.PO_ASL_UPGRADE_SV dependencies on PO_AUTOSOURCE_RULES

Line 17: x_autosource_rule_name po_autosource_rules.autosource_rule_name%type := '';

13: ) IS
14: x_progress VARCHAR2(30) := '';
15: x_dummy_count NUMBER;
16: x_autosource_rule_id NUMBER;
17: x_autosource_rule_name po_autosource_rules.autosource_rule_name%type := '';
18: x_item_id NUMBER;
19: x_start_date DATE;
20: x_end_date DATE;
21: x_last_update_date DATE;

Line 52: FROM PO_AUTOSOURCE_RULES;

48: x_attribute15 po_autosource_vendors.attribute15%type;
49:
50: CURSOR C2 is
51: SELECT DISTINCT ITEM_ID
52: FROM PO_AUTOSOURCE_RULES;
53:
54: CURSOR C1 is
55: SELECT AUTOSOURCE_RULE_ID,
56: AUTOSOURCE_RULE_NAME,

Line 80: FROM PO_AUTOSOURCE_RULES

76: attribute12,
77: attribute13,
78: attribute14,
79: attribute15
80: FROM PO_AUTOSOURCE_RULES
81: WHERE ITEM_ID = x_item_id
82: ORDER BY start_date;
83:
84: CURSOR I1 is

Line 123: -- For each item in po_autosource_rules, determine whether a sourcing

119: return;
120: END IF;
121:
122:
123: -- For each item in po_autosource_rules, determine whether a sourcing
124: -- rule has already been assigned to that item. If so, do not upgrade
125: -- the autosource rules for this item. Otherwise, define a new sourcing
126: -- rule for the item and assign it to the item.
127: