60: TYPE Rev_Comp_Disable_Date_Tbl_Type IS TABLE OF Rev_Comp_Disable_Date_Rec_Type
61: INDEX BY BINARY_INTEGER ;
62:
63: Procedure implement_revised_item(
64: revised_item in eng_revised_items.revised_item_sequence_id%type,
65: trial_mode in number,
66: max_messages in number, -- size of host arrays
67: userid in number, -- user id
68: reqstid in number, -- concurrent request id
68: reqstid in number, -- concurrent request id
69: appid in number, -- application id
70: progid in number, -- program id
71: loginid in number, -- login id
72: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type,
73: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type,
74: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type,
75: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
76: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
69: appid in number, -- application id
70: progid in number, -- program id
71: loginid in number, -- login id
72: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type,
73: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type,
74: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type,
75: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
76: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
77: update_wip OUT NOCOPY eng_revised_items.update_wip%type,
70: progid in number, -- program id
71: loginid in number, -- login id
72: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type,
73: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type,
74: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type,
75: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
76: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
77: update_wip OUT NOCOPY eng_revised_items.update_wip%type,
78: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
73: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type,
74: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type,
75: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
76: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
77: update_wip OUT NOCOPY eng_revised_items.update_wip%type,
78: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
79: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
80: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
81: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,
90: msg_qty in OUT NOCOPY binary_integer,
91: warnings in OUT NOCOPY number);
92:
93: Procedure reverse_standard_bom(
94: revised_item in eng_revised_items.revised_item_sequence_id%type,
95: userid in number,
96: reqstid in number,
97: appid in number,
98: progid in number,
96: reqstid in number,
97: appid in number,
98: progid in number,
99: loginid in number,
100: bill_sequence_id in eng_revised_items.bill_sequence_id%type,
101: routing_sequence_id in eng_revised_items.routing_sequence_id%type,
102: return_message OUT NOCOPY VARCHAR2,
103: return_status in OUT NOCOPY NUMBER
104: );
97: appid in number,
98: progid in number,
99: loginid in number,
100: bill_sequence_id in eng_revised_items.bill_sequence_id%type,
101: routing_sequence_id in eng_revised_items.routing_sequence_id%type,
102: return_message OUT NOCOPY VARCHAR2,
103: return_status in OUT NOCOPY NUMBER
104: );
105: