1 PACKAGE PO_CREATE_SR_ASL AUTHID CURRENT_USER AS
2 /* $Header: POXWSRAS.pls 120.1.12020000.2 2013/02/10 22:23:28 vegajula ship $ */
3
4 /*=======================================================================+
5 | FILENAME
6 | POXWSRS.pls
7 |
8 | DESCRIPTION
9 | PL/SQL package: PO_CREATE_SR_ASL
10 |
11 | NOTES
12
13 | MODIFIED (MM/DD/YY)
14 |
15 *=======================================================================*/
16
17 procedure PROCESS_PO_LINES_FOR_SR_ASL( itemtype in varchar2,
18 itemkey in varchar2,
19 actid in number,
20 funcmode in varchar2,
21 resultout out NOCOPY varchar2);
22
23 PROCEDURE GET_LINE_FOR_PROCESS
24 (
25 x_header_id IN NUMBER, -- PO Header ID
26 x_prev_line_num IN NUMBER, -- Line number last processed
27 x_line_id OUT NOCOPY NUMBER, -- PO Line ID
28 x_line_num OUT NOCOPY NUMBER, -- PO Line Num
29 x_vendor_id OUT NOCOPY NUMBER, -- Vendor ID
30 x_vendor_site_id OUT NOCOPY NUMBER, -- Vendor Site ID
31 x_item_id OUT NOCOPY NUMBER, -- Inventory Item ID
32 x_approved_flag OUT NOCOPY VARCHAR2, -- Approval Status
33 x_start_date OUT NOCOPY DATE,
34 x_end_date OUT NOCOPY DATE,
35 x_interface_header_id OUT NOCOPY NUMBER,
36 x_interface_line_id OUT NOCOPY NUMBER,
37 x_org_assign_change IN VARCHAR2 default null
38 ); -- GA FPI
39
40
41 procedure Create_ASL (itemtype in varchar2,
42 itemkey in varchar2,
43 actid in number,
44 funcmode in varchar2,
45 resultout out NOCOPY varchar2);
46
47
48 procedure Create_Sourcing_Rule(itemtype in varchar2,
49 itemkey in varchar2,
50 actid in number,
51 funcmode in varchar2,
52 resultout out NOCOPY varchar2);
53 --<LOCAL SR/ASL PROJECT 11i11 START>
54 PROCEDURE CREATE_AUTOSOURCE_RULES(
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE ,
57 p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_document_id IN PO_HEADERS_ALL.po_header_id%type,
62 p_vendor_id IN PO_HEADERS_ALL.vendor_id%type,
63 p_purchasing_org_id IN PO_HEADERS_ALL.org_id%type,
64 p_vendor_site_id IN PO_HEADERS_ALL.vendor_site_id%type,
65 p_create_sourcing_rule IN VARCHAR2,
66 p_update_sourcing_rule IN VARCHAR2,
67 p_agreement_lines_selection IN VARCHAR2 ,
68 p_sourcing_level IN VARCHAR2,
69 p_inv_org IN HR_ALL_ORGANIZATION_UNITS.organization_id%type,
70 p_sourcing_rule_name IN VARCHAR2,
71 p_release_gen_method IN PO_ASL_ATTRIBUTES.release_generation_method%type,
72 p_assignment_set_id IN MRP_ASSIGNMENT_SETS.assignment_set_id%type) ;
73
74 PROCEDURE CREATE_SOURCING_RULES_ASL
75 (
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
78 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%type,
83 p_interface_line_id IN PO_LINES_INTERFACE.interface_line_id%type,
84 p_document_id IN PO_HEADERS.po_header_id%type,
85 p_po_line_id IN PO_LINES.po_line_id%type,
86 p_document_type IN PO_HEADERS.type_lookup_code%type,
87 p_approval_status IN VARCHAR2,
88 p_vendor_id IN PO_HEADERS.vendor_id%type,
89 p_vendor_site_id IN PO_HEADERS.vendor_site_id%type,
90 p_inv_org_id IN HR_ALL_ORGANIZATION_UNITS.organization_id%type,
91 p_sourcing_level IN VARCHAR2,
92 p_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%type,
93 p_category_id IN MTL_ITEM_CATEGORIES.category_id%type,
94 p_rel_gen_method IN PO_ASL_ATTRIBUTES.release_generation_method%type,
95 p_rule_name IN MRP_SOURCING_RULES.sourcing_rule_name%type,
96 p_rule_name_prefix IN VARCHAR2,
97 p_start_date IN DATE,
98 p_end_date IN DATE,
99 p_assignment_set_id IN MRP_ASSIGNMENT_SETS.assignment_set_id%type,
100 p_create_update_code IN VARCHAR2,
101 p_interface_error_code IN VARCHAR2,
102 x_header_processable_flag IN OUT NOCOPY VARCHAR2
103 );
104 --<LOCAL SR/ASL PROJECT 11i11 END>
105
106 /* Bug 10417292 - Launching Conucrrent Request for Creating ASL and SR
107 Instead of doing it in workflow*/
108
109 procedure CREATE_SR_ASL
110 ( itemtype in varchar2,
111 itemkey in varchar2,
112 actid in number,
113 funcmode in varchar2,
114 resultout out NOCOPY varchar2
115 );
116 END PO_CREATE_SR_ASL;
[Home] [Help]