DBA Data[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;