1 PACKAGE po_copydoc_s1 AUTHID CURRENT_USER AS
2 /* $Header: POXCPO1S.pls 120.5 2010/02/28 13:49:32 ssreekum ship $*/
3
4 -- Constants for the x_message_type parameter in po_online_report:
5 G_ERROR_MESSAGE_TYPE VARCHAR2(1) := 'E';
6 G_WARNING_MESSAGE_TYPE VARCHAR2(1) := 'W';
7
8 /* Functionality for PA->RFQ Copy : dreddy
9 new parameter copy_price is added */
10 PROCEDURE copy_document(
11 x_action_code IN VARCHAR2,
12 x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
13 x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
14 x_copy_attachments IN BOOLEAN,
15 x_copy_price IN BOOLEAN,
16 x_from_po_header_id IN po_headers.po_header_id%TYPE,
17 x_to_po_header_id OUT NOCOPY po_headers.po_header_id%TYPE,
18 x_online_report_id OUT NOCOPY po_online_report_text.online_report_id%TYPE,
19 x_to_segment1 IN OUT NOCOPY po_headers.segment1%TYPE,
20 x_agent_id IN po_headers.agent_id%TYPE,
21 x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
22 x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
23 x_wip_install_status IN VARCHAR2,
24 x_return_code OUT NOCOPY NUMBER,
25 x_copy_terms IN VARCHAR2, --<CONTERMS FPJ>
26 p_api_commit IN BOOLEAN DEFAULT TRUE, --<HTML Agreements R12>
27 p_from_doc_type IN VARCHAR2 DEFAULT NULL --<R12 eTax Integration>
28 );
29
30 PROCEDURE online_report(
31 x_online_report_id IN po_online_report_text.online_report_id%TYPE,
32 x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
33 x_message IN po_online_report_text.text_line%TYPE,
34 x_line_num IN po_online_report_text.line_num%TYPE,
35 x_shipment_num IN po_online_report_text.shipment_num%TYPE,
36 x_distribution_num IN po_online_report_text.distribution_num%TYPE,
37 x_message_type IN VARCHAR2 := G_ERROR_MESSAGE_TYPE -- <PO_PJM_VALIDATION FPI>
38 );
39
40 PROCEDURE copydoc_sql_error(
41 x_routine IN VARCHAR2,
42 x_progress IN VARCHAR2,
43 x_sqlcode IN NUMBER,
44 x_online_report_id IN po_online_report_text.online_report_id%TYPE,
45 x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
46 x_line_num IN po_online_report_text.line_num%TYPE,
47 x_shipment_num IN po_online_report_text.shipment_num%TYPE,
48 x_distribution_num IN po_online_report_text.distribution_num%TYPE
49 );
50
51 PROCEDURE copydoc_debug(
52 x_message IN VARCHAR2
53 );
54
55 -- Bug 2744363
56 /**
57 * Returns TRUE if the given PO has any drop shipments, FALSE otherwise.
58 **/
59 FUNCTION po_is_dropship (
60 p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
61 ) RETURN BOOLEAN;
62
63
64
65 -- <CONFIG_ID FPJ START>
66
67 FUNCTION po_has_config_id(
68 p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
69 ) RETURN BOOLEAN;
70
71 FUNCTION req_has_config_id(
72 p_requisition_header_id IN PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE
73 ) RETURN BOOLEAN;
74
75 -- <CONFIG_ID FPJ END>
76 --<HTML Agreements R12 Start>
77 procedure val_params_and_duplicate_doc( p_po_header_id IN NUMBER
78 ,p_copy_attachment IN VARCHAR2
79 ,p_copy_terms IN VARCHAR2
80 ,x_new_segment1 IN OUT NOCOPY VARCHAR2
81 ,x_new_po_header_id OUT NOCOPY NUMBER
82 ,x_errmsg_code OUT NOCOPY VARCHAR2
83 ,x_message_type OUT NOCOPY VARCHAR2
84 ,x_text_line OUT NOCOPY VARCHAR2
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_exception_msg OUT NOCOPY VARCHAR2);
87
88 PROCEDURE ret_and_del_online_report_rec( p_online_report_id IN NUMBER
89 ,x_message_type OUT NOCOPY VARCHAR2
90 ,x_message OUT NOCOPY VARCHAR2);
91 --<HTML Agreements R12 End>
92
93 -- For CLM project
94 PROCEDURE COPY_UDA_ATTRS
95 (
96 p_level IN VARCHAR2
97 ,p_from_po_header_id IN NUMBER
98 ,p_from_pk_value IN NUMBER
99 ,p_to_pk_value IN NUMBER
100 ,x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE
101 ,x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE
102 ,x_po_shipment_record IN OUT NOCOPY PO_LINE_LOCATIONS%ROWTYPE
103 ,x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE
104 ,x_return_status OUT NOCOPY VARCHAR2
105 ,x_msg_count OUT NOCOPY NUMBER
106 ,x_msg_data OUT NOCOPY VARCHAR2
107 );
108 -- For CLM project
109
110
111 END po_copydoc_s1;
[Home] [Help]