[Home] [Help]
PACKAGE: APPS.POS_ACK_SEARCH
Source
1 PACKAGE POS_ACK_SEARCH AUTHID CURRENT_USER AS
2 /* $Header: POSASRCS.pls 115.2 2000/08/02 18:23:40 pkm ship $ */
3
4 g_user_id NUMBER;
5 g_responsibility_id NUMBER;
6 TYPE g_text_table is table of varchar2(240) index by binary_integer;
7 g_dummy_tbl g_text_table;
8
9
10 PROCEDURE SEARCH_PO2(p_resp_id IN VARCHAR2 DEFAULT null);
11 PROCEDURE SEARCH_PO (
12 pk1 IN varchar2 default null,
13 pk2 IN varchar2 default null,
14 pk3 IN varchar2 default null,
15 pk4 IN varchar2 default null,
16 pk5 IN varchar2 default null,
17 pk6 IN varchar2 default null,
18 pk7 IN varchar2 default null,
19 pk8 IN varchar2 default null,
20 pk9 IN varchar2 default null,
21 pk10 IN varchar2 default null,
22 c_outputs1 OUT varchar2,
23 c_outputs2 OUT varchar2,
24 c_outputs3 OUT varchar2,
25 c_outputs4 OUT varchar2,
26 c_outputs5 OUT varchar2,
27 c_outputs6 OUT varchar2,
28 c_outputs7 OUT varchar2,
29 c_outputs8 OUT varchar2,
30 c_outputs9 OUT varchar2,
31 c_outputs10 OUT varchar2
32 );
33 PROCEDURE FIXED_FRAME(l_supplier_contact IN number);
34 PROCEDURE CRITERIA_FRAME(p_advance_flag IN VARCHAR2 DEFAULT 'N',
35 l_po_number IN VARCHAR2 DEFAULT null
36 );
37 PROCEDURE COUNTER_FRAME(
38 p_first IN NUMBER DEFAULT 0,
39 p_last IN NUMBER DEFAULT 0,
40 p_total IN NUMBER DEFAULT 0
41 );
42
43 PROCEDURE BLANK_FRAME (
44 l_called_from IN NUMBER DEFAULT 0,
45 l_rows_inserted IN NUMBER DEFAULT 0
46 );
47 PROCEDURE ADD_FRAME (
48 p_total IN NUMBER default 0
49 ) ;
50 PROCEDURE RESULT_POS
51 (
52 p_advance_flag IN VARCHAR2 DEFAULT 'N',
53 pos_ack_sr_acc_status IN VARCHAR2 DEFAULT null,
54 pos_ack_sr_acc_reqd IN VARCHAR2 DEFAULT null,
55 pos_ack_sr_acc_reqd_start_date IN VARCHAR2 DEFAULT null,
56 pos_ack_sr_acc_reqd_end_date IN VARCHAR2 DEFAULT null,
57 pos_ack_sr_po_number IN VARCHAR2 DEFAULT null,
58 pos_ack_sr_supplier_site_id IN VARCHAR2 DEFAULT null,
59 pos_ack_supplier_site IN VARCHAR2 DEFAULT null,
60 pos_ack_sr_doc_type IN VARCHAR2 DEFAULT null,
61 pos_ack_sr_row_num IN VARCHAR2 DEFAULT null
62
63 );
64
65 PROCEDURE SHOW_POS(
66 pos_ack_sr_row_num IN VARCHAR2 default '0',
67 l_rows_inserted IN NUMBER default 0
68 );
69
70 PROCEDURE Find_Matching_Rows (
71 l_Acceptance_Status IN VARCHAR2 default null,
72 l_Acceptance_Reqd_Flag IN VARCHAR2 default null,
73 l_Start_Date IN VARCHAR2 default null,
74 l_End_Date IN VARCHAR2 default null,
75 l_PO_Number IN VARCHAR2 default null,
76 l_Supplier_Site_Id IN VARCHAR2 default null,
77 l_Document_Type_Code IN VARCHAR2 default null
78 );
79
80 PROCEDURE ACKNOWLEDGE_POS (
81 pos_ack_row_num IN g_text_table default g_dummy_tbl,
82 pos_ack_accept IN g_text_table default g_dummy_tbl,
83 pos_ack_acc_type IN g_text_table default g_dummy_tbl,
84 pos_ack_comments IN g_text_table default g_dummy_tbl,
85 --pos_ack_document_type IN g_text_table default g_dummy_tbl,
86 --pos_ack_currency IN g_text_table default g_dummy_tbl,
87 --pos_ack_total IN g_text_table default g_dummy_tbl,
88 --pos_ack_approval_status IN g_text_table default g_dummy_tbl,
89 pos_ack_shipto_loc IN g_text_table default g_dummy_tbl,
90 pos_ack_carrier IN g_text_table default g_dummy_tbl,
91 pos_ack_po_header_id IN g_text_table default g_dummy_tbl,
92 pos_ack_release_id IN g_text_table default g_dummy_tbl,
93 pos_ack_buyer_id IN g_text_table default g_dummy_tbl,
94 pos_ack_acc_type_code IN g_text_table default g_dummy_tbl
95 );
96
97 FUNCTION po_num(seg1 in varchar2, po_header_id in number default null) RETURN VARCHAR2;
98
99 FUNCTION GET_SUPPLIER_ID (p_user_id IN NUMBER) RETURN NUMBER;
100 PROCEDURE Paint_Search_Fields (p_advance_flag IN VARCHAR2,
101 l_po_number IN VARCHAR2 DEFAULT null
102 );
103 PROCEDURE PAINT_EDIT_POS(l_row_num NUMBER default 0);
104 PROCEDURE DISPLAY_LOG;
105 PROCEDURE CLEAR_LOG;
106
107 FUNCTION item_halign(l_index in number) RETURN VARCHAR2;
108 FUNCTION item_valign(l_index in number) RETURN VARCHAR2;
109 FUNCTION item_name(l_index in number) RETURN VARCHAR2;
110 FUNCTION item_code(l_index in number) RETURN VARCHAR2;
111 FUNCTION item_style(l_index in number) RETURN VARCHAR2;
112 FUNCTION item_displayed(l_index in number) RETURN BOOLEAN;
113 FUNCTION item_updateable(l_index in number) RETURN BOOLEAN;
114 FUNCTION item_reqd(l_index in number) RETURN VARCHAR2;
115 FUNCTION item_size(l_index in number) RETURN VARCHAR2;
116 FUNCTION get_option_string(l_index in number) RETURN VARCHAR2;
117 FUNCTION get_result_value(p_index in number, p_col in number) return varchar2;
118 FUNCTION buyer(seg1 in varchar2, po_header_id in number default null) RETURN VARCHAR2;
119 PROCEDURE veera_debug(p_debug_string in varchar2);
120 procedure button(src IN varchar2, txt IN varchar2);
121 procedure button(src1 IN varchar2, txt1 IN varchar2, src2 IN varchar2, txt2 IN varchar2);
122 END POS_ACK_SEARCH;