1 PACKAGE PO_ACCEPTANCES_INS_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVIACS.pls 120.4 2011/12/29 12:54:13 pamandav ship $*/
3 -- Bug 2850566
4 -- Modified the specs to accomodate new columns and defaulted the parameters to Null.
5
6 -- CLM Apprvl, Overloaded procedure insert_row to include a new parameter draft_id for the modification documents.
7
8 PROCEDURE insert_row(
9 x_rowid IN OUT NOCOPY ROWID,
10 x_acceptance_id IN OUT NOCOPY NUMBER,
11 x_last_update_date IN OUT NOCOPY DATE,
12 x_last_updated_by IN OUT NOCOPY NUMBER,
13 x_last_update_login IN OUT NOCOPY NUMBER,
14 p_creation_date IN DATE DEFAULT NULL,
15 p_created_by IN NUMBER DEFAULT NULL,
16 p_po_header_id IN NUMBER DEFAULT NULL,
17 p_draft_id IN NUMBER DEFAULT NULL, -- CLM Apprvl
18 p_po_release_id IN NUMBER DEFAULT NULL,
19 p_action IN VARCHAR2 DEFAULT NULL,
20 p_action_date IN DATE DEFAULT NULL,
21 p_employee_id IN NUMBER DEFAULT NULL,
22 p_revision_num IN NUMBER DEFAULT NULL,
23 p_accepted_flag IN VARCHAR2 DEFAULT NULL,
24 p_acceptance_lookup_code IN VARCHAR2 DEFAULT NULL,
25 p_note IN CLOB DEFAULT NULL,
26 p_accepting_party IN VARCHAR2 DEFAULT NULL,
27 p_signature_flag IN VARCHAR2 DEFAULT NULL,
28 p_erecord_id IN NUMBER DEFAULT NULL,
29 p_role IN VARCHAR2 DEFAULT NULL,
30 p_attribute_category IN VARCHAR2 DEFAULT NULL,
31 p_attribute1 IN VARCHAR2 DEFAULT NULL,
32 p_attribute2 IN VARCHAR2 DEFAULT NULL,
33 p_attribute3 IN VARCHAR2 DEFAULT NULL,
34 p_attribute4 IN VARCHAR2 DEFAULT NULL,
35 p_attribute5 IN VARCHAR2 DEFAULT NULL,
36 p_attribute6 IN VARCHAR2 DEFAULT NULL,
37 p_attribute7 IN VARCHAR2 DEFAULT NULL,
38 p_attribute8 IN VARCHAR2 DEFAULT NULL,
39 p_attribute9 IN VARCHAR2 DEFAULT NULL,
40 p_attribute10 IN VARCHAR2 DEFAULT NULL,
41 p_attribute11 IN VARCHAR2 DEFAULT NULL,
42 p_attribute12 IN VARCHAR2 DEFAULT NULL,
43 p_attribute13 IN VARCHAR2 DEFAULT NULL,
44 p_attribute14 IN VARCHAR2 DEFAULT NULL,
45 p_attribute15 IN VARCHAR2 DEFAULT NULL,
46 p_request_id IN NUMBER DEFAULT NULL,
47 p_program_application_id IN NUMBER DEFAULT NULL,
48 p_program_id IN NUMBER DEFAULT NULL,
49 p_program_update_date IN DATE DEFAULT NULL,
50 p_po_line_location_id IN NUMBER DEFAULT NULL,
51 p_vendor_contact_id IN NUMBER DEFAULT NULL, -- CLM Apprvl signature process
52 p_vendor_contact_name IN VARCHAR2 DEFAULT NULL, -- CLM Apprvl signature process
53 p_vendor_contact_title IN VARCHAR2 DEFAULT NULL, -- CLM Apprvl signature process
54 p_vendor_signed_date IN DATE DEFAULT NULL -- CLM Apprvl signature process
55 );
56
57 END PO_ACCEPTANCES_INS_PVT;