[Home] [Help]
PACKAGE: APPS.POS_ASN_DETAILS_S
Source
1 PACKAGE pos_asn_details_s AUTHID CURRENT_USER AS
2 /* $Header: POSASNDS.pls 115.1 1999/11/30 12:19:43 pkm ship $ */
3
4 l_language VARCHAR2(5);
5 l_script_name VARCHAR2(240);
6 l_org_id NUMBER;
7 l_user_id NUMBER;
8 l_session_id NUMBER;
9 l_responsibility_id NUMBER;
10 g_flag VARCHAR2(1);
11 g_quantity VARCHAR2(38);
12 g_unit_of_measure VARCHAR2(25);
13
14 TYPE t_text_table is table of varchar2(240) index by binary_integer;
15 g_dummy t_text_table;
16
17 FUNCTION set_session_info RETURN BOOLEAN;
18 FUNCTION get_result_value(p_index in number, p_col in number) return varchar2;
19
20 FUNCTION item_halign(l_index in number) RETURN VARCHAR2;
21 FUNCTION item_valign(l_index in number) RETURN VARCHAR2;
22 FUNCTION item_name(l_index in number) RETURN VARCHAR2;
23 FUNCTION item_code(l_index in number) RETURN VARCHAR2;
24 FUNCTION item_style(l_index in number) RETURN VARCHAR2;
25 FUNCTION item_displayed(l_index in number) RETURN BOOLEAN;
26 FUNCTION item_updateable(l_index in number) RETURN BOOLEAN;
27 FUNCTION item_sequence(l_index in number) RETURN NUMBER;
28 FUNCTION item_maxlength (l_index in number) RETURN VARCHAR2;
29 FUNCTION item_size (l_index in number) RETURN VARCHAR2;
30 FUNCTION item_lov(l_index in number) RETURN VARCHAR2;
31
32 PROCEDURE show_details(p_asn_line_id VARCHAR2,
33 p_asn_line_split_id VARCHAR2,
34 p_quantity VARCHAR2 DEFAULT NULL,
35 p_unit_of_measure VARCHAR2 DEFAULT NULL);
36
37
38 PROCEDURE set_asn_ids(p_asn_line_id VARCHAR2, p_asn_line_split_id VARCHAR2);
39 PROCEDURE paint_region_title(p_product VARCHAR2,
40 p_title VARCHAR2);
41 PROCEDURE paint_single_record_prompt(p_attribute_index NUMBER);
42 PROCEDURE paint_updateable_field(p_attribute_index NUMBER,
43 p_result_index NUMBER,
44 p_current_col NUMBER);
45 PROCEDURE paint_nonupdateable_field(p_attribute_index NUMBER,
46 p_result_index NUMBER,
47 p_current_col NUMBER,
48 p_colspan NUMBER DEFAULT NULL);
49
50 PROCEDURE paint_hidden_field(p_attribute_index NUMBER,
51 p_result_index NUMBER,
52 p_current_col NUMBER);
53
54 PROCEDURE paint_shipment_details(p_asn_line_id VARCHAR2,
55 p_asn_line_split_id VARCHAR2,
56 p_region VARCHAR2);
57
58
59 PROCEDURE update_details(pos_asn_line_id IN VARCHAR2 DEFAULT NULL,
60 pos_asn_line_split_id IN VARCHAR2 DEFAULT NULL,
61 pos_expected_receipt_date IN VARCHAR2 DEFAULT NULL,
62 pos_packing_slip IN VARCHAR2 DEFAULT NULL,
63 pos_waybill_airbill_num IN VARCHAR2 DEFAULT NULL,
64 pos_bill_of_lading IN VARCHAR2 DEFAULT NULL,
65 pos_barcode_label IN VARCHAR2 DEFAULT NULL,
66 pos_country_of_origin IN VARCHAR2 DEFAULT NULL,
67 pos_country_of_origin_code IN VARCHAR2 DEFAULT NULL,
68 pos_vendor_cum_shipped_qty IN VARCHAR2 DEFAULT NULL,
69 pos_num_of_containers IN VARCHAR2 DEFAULT NULL,
70 pos_container_num IN VARCHAR2 DEFAULT NULL,
71 pos_vendor_lot_num IN VARCHAR2 DEFAULT NULL,
72 pos_freight_carrier IN VARCHAR2 DEFAULT NULL,
73 pos_freight_carrier_code IN VARCHAR2 DEFAULT NULL,
74 pos_truck_num IN VARCHAR2 DEFAULT NULL,
75 pos_reason_id IN VARCHAR2 DEFAULT NULL,
76 pos_reason_name IN VARCHAR2 DEFAULT NULL,
77 pos_ship_to_organization_id IN VARCHAR2 DEFAULT NULL);
78
79
80 END pos_asn_details_s;