PACKAGE: APPS.OE_GENESIS_UTIL

Source

1 PACKAGE OE_GENESIS_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEXUGNIS.pls 120.5 2011/04/25 07:31:55 snimmaga ship $ */
3 
4 -- AIA Enablement status
5 TYPE enabled_source_rec_typ IS RECORD ( enabled VARCHAR2(1) );
6 TYPE enabled_sources_tab_typ IS TABLE OF enabled_source_rec_typ
7      INDEX BY BINARY_INTEGER;
8 g_enabled_sources_tab   enabled_sources_tab_typ;
9 g_sources_loaded  BOOLEAN := FALSE;
10 
11 G_INCOMING_FROM_DOO BOOLEAN := FALSE; -- DOO Pre Exploded Kit ER 9339742
12 G_INCOMING_FROM_SIEBEL BOOLEAN := FALSE; -- DOO Pre Exploded Kit ER 9339742
13 
14 FUNCTION source_aia_enabled (p_source_id VARCHAR2) RETURN BOOLEAN;
15 
16 PROCEDURE Convert_hdr_null_to_miss
17 (   p_x_header_rec        IN OUT NOCOPY  OE_Order_PUB.Header_Rec_Type
18 );
19 
20 PROCEDURE Convert_hdr_pymnt_null_to_miss
21 (   p_x_Header_Payment_rec  IN OUT NOCOPY  OE_Order_PUB.Header_Payment_Rec_Type
22 );
23 
24 PROCEDURE Convert_Line_null_to_miss
25 (   p_x_line_rec                    IN OUT NOCOPY  OE_Order_PUB.Line_Rec_Type
26 );
27 
28 ----- O2C25
29 --  To get the name of inventory organization.
30 FUNCTION Inventory_Org
31 (
32   p_inventory_org_id         IN  NUMBER
33 ) RETURN VARCHAR2;
34 
35 -- For flow status synchronization
36 TYPE  status_sync_setup_rec IS RECORD (
37                                         flow_status_code  VARCHAR2(30),
38                                         object_level      VARCHAR2(4)
39                                       );
40 
41 TYPE status_sync_setup_tab IS TABLE OF status_sync_setup_rec
42   INDEX BY VARCHAR2(30);
43 
44 g_status_setup_loaded   BOOLEAN := FALSE;
45 g_status_setup_tab      status_sync_setup_tab;
46 
47 FUNCTION status_needs_sync(
48                             p_flow_status_code  VARCHAR2,
49                             p_object_level      VARCHAR2 DEFAULT NULL
50                           )
51   RETURN BOOLEAN;
52 
53 -- To convert OE_ORDER_PUB_HEADER_REC_TYPE to OE_ORDER_PUB_HDR_REC25
54 PROCEDURE header_rec_to_hdr_rec25(
55     p_header_rec IN         oe_order_pub_header_rec_type,
56     x_hdr_rec25  OUT NOCOPY oe_order_pub_hdr_rec25
57 );
58 
59 -- To convert OE_ORDER_PUB_LINE_REC_TYP to OE_ORDER_PUB_LIN_REC25
60 PROCEDURE line_rec_to_line_rec25(
61     p_line_rec    IN          oe_order_pub_line_rec_type,
62     x_line_rec25  OUT NOCOPY  oe_order_pub_line_rec25
63 );
64 
65 -- To convert OE_ORDER_PUB_LINE_TBL_TYPE to OE_ORDER_PUB_LIN_TBL25
66 PROCEDURE line_tab_to_line_tab25(
67     p_line_tab    IN          oe_order_pub_line_tbl_type,
68     x_line_tab25  OUT NOCOPY  oe_order_pub_line_tab25
69 );
70 
71 -- To convert OE_ACKNOWLEDGMENT_PUB_HEADER_ to OE_ACK_PUB_HDR_REC25
72 PROCEDURE hdr_ack_rec_to_hdr_ack_rec25(
73     p_hdr_ack_rec   IN            oe_acknowledgment_pub_header_,
74     x_hdr_ack_rec25 OUT NOCOPY    oe_ack_pub_hdr_rec25
75 );
76 
77 -- To convert OE_SYNC_ORDER_PVT_HEADER_ACK_ to OE_ACK_PUB_HDR_TAB25
78 PROCEDURE hdr_ack_tab_to_hdr_ack_tab25(
79     p_hdr_ack_tab     IN            oe_sync_order_pvt_header_ack_,
80     x_hdr_ack_tab25   OUT NOCOPY    oe_ack_pub_hdr_tab25
81 );
82 
83 -- To convert OE_ACKNOWLEDGMENT_PUB_LINE_AC to OE_ACK_PUB_LINE_REC25
84 PROCEDURE line_ack_rec_to_line_ack_rec25(
85     p_line_ack_rec    IN          oe_acknowledgment_pub_line_ac,
86     x_line_ack_rec25  OUT NOCOPY  oe_ack_pub_line_rec25
87 );
88 
89 
90 -- To convert OE_SYNC_ORDER_PVT_LINE_ACK_TB to OE_ACK_PUB_LINE_TAB25
91 PROCEDURE line_ack_tab_to_line_ack_tab25(
92     p_line_ack_tab    IN          oe_sync_order_pvt_line_ack_tb,
93     x_line_ack_tab25  OUT NOCOPY  oe_ack_pub_line_tab25
94 );
95 
96 ----- O2C25
97 
98 procedure print_po_payload (
99       P_HEADER_REC OE_ORDER_PUB.HEADER_REC_TYPE,
100       P_HEADER_VAL_REC OE_ORDER_PUB.HEADER_VAL_REC_TYPE,
101       P_HEADER_PAYMENT_TBL OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE,
102       P_LINE_TBL OE_ORDER_PUB.LINE_TBL_TYPE
103       );
104 
105 
106 END OE_GENESIS_UTIL;