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
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
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.
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: );
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
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(
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: );
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
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(
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: );
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
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(
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: );
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:
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:
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;