30:
31: WHILE l_index IS NOT NULL LOOP
32:
33: -- Ignore if dependent attribute is one of the internal fields.
34: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
35: IF l_extn_dep_tbl(l_index).dependent_attribute IN
36: ( OE_HEADER_UTIL.G_ORDER_CATEGORY
37: ) THEN
38: IF l_debug_level > 0 THEN
39: oe_debug_pub.add( 'INTERNAL FIELD DEPENDENCY' ) ;
40: END IF;
41: GOTO END_OF_LOOP;
42: END IF;
43: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
44: IF l_extn_dep_tbl(l_index).dependent_attribute IN
45: ( OE_LINE_UTIL.G_LINE_CATEGORY
46: , OE_LINE_UTIL.G_SHIPMENT_NUMBER
47: , OE_LINE_UTIL.G_OPTION_NUMBER
61: END IF;
62: GOTO END_OF_LOOP;
63: END IF;
64: --serla begin
65: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT THEN
66: IF l_extn_dep_tbl(l_index).dependent_attribute IN
67: ( OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE
68: ) THEN
69: IF l_debug_level > 0 THEN
70: oe_debug_pub.add( 'INTERNAL FIELD DEPENDENCY' ) ;
71: END IF;
72: GOTO END_OF_LOOP;
73: END IF;
74: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
75: IF l_extn_dep_tbl(l_index).dependent_attribute IN
76: ( OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE
77: ) THEN
78: IF l_debug_level > 0 THEN
151: END IF;
152:
153: g_entity_code := p_entity_code;
154:
155: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
156:
157: -- Populate dependent attributes for one source at a time.
158:
159: l_index := OE_HEADER_UTIL.G_ORDER_TYPE * G_MAX ;
381: l_index := OE_HEADER_UTIL.G_ORDERED_DATE * G_MAX ;
382: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_ORDER_FIRMED_DATE;
383: END IF;
384:
385: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
386:
387: l_index := OE_LINE_UTIL.G_LINE_NUMBER * G_MAX ;
388: g_dep_tbl(l_index ).attribute := OE_LINE_UTIL.G_SHIPMENT_NUMBER;
389: g_dep_tbl(l_index+1 ).attribute := OE_LINE_UTIL.G_OPTION_NUMBER;
676: g_dep_tbl(l_index).attribute := OE_LINE_UTIL.G_END_CUSTOMER_CONTACT;
677: g_dep_tbl(l_index+1).attribute := OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE;
678: END IF;
679:
680: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_ADJ THEN
681:
682: null;
683: /*
684: l_index := OE_HEADER_ADJ_UTIL.G_DISCOUNT * G_MAX;
691: g_dep_tbl(l_index+1).attribute := OE_HEADER_ADJ_UTIL.g_percent;
692:
693: */
694:
695: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_ADJ THEN
696: null;
697:
698: /*
699: l_index := OE_LINE_ADJ_UTIL.G_DISCOUNT * G_MAX;
706: g_dep_tbl(l_index+1).attribute := OE_LINE_ADJ_UTIL.g_percent;
707:
708: */
709: --serla begin
710: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_PAYMENT THEN
711:
712: l_index := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE * G_MAX ;
713: g_dep_tbl(l_index ).attribute := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID;
714: g_dep_tbl(l_index+1 ).attribute := OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID;
758: l_index := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE * G_MAX ;
759: g_dep_tbl(l_index ).attribute := OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER;
760: g_dep_tbl(l_index+1 ).attribute := OE_HEADER_PAYMENT_UTIL.G_TANGIBLE_ID;
761:
762: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
763:
764: l_index := OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE * G_MAX ;
765: g_dep_tbl(l_index ).attribute := OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID;
766: g_dep_tbl(l_index+1 ).attribute := OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID;
833:
834:
835: PROCEDURE Mark_Dependent
836: ( p_entity_code IN VARCHAR2 ,
837: p_source_attr_tbl IN OE_GLOBALS.Number_Tbl_Type :=
838: OE_GLOBALS.G_MISS_NUMBER_TBL ,
839: p_dep_attr_tbl OUT NOCOPY OE_GLOBALS.Number_Tbl_Type
840:
841: )
834:
835: PROCEDURE Mark_Dependent
836: ( p_entity_code IN VARCHAR2 ,
837: p_source_attr_tbl IN OE_GLOBALS.Number_Tbl_Type :=
838: OE_GLOBALS.G_MISS_NUMBER_TBL ,
839: p_dep_attr_tbl OUT NOCOPY OE_GLOBALS.Number_Tbl_Type
840:
841: )
842: IS
835: PROCEDURE Mark_Dependent
836: ( p_entity_code IN VARCHAR2 ,
837: p_source_attr_tbl IN OE_GLOBALS.Number_Tbl_Type :=
838: OE_GLOBALS.G_MISS_NUMBER_TBL ,
839: p_dep_attr_tbl OUT NOCOPY OE_GLOBALS.Number_Tbl_Type
840:
841: )
842: IS
843: l_index NUMBER;
841: )
842: IS
843: l_index NUMBER;
844: l_out_index NUMBER;
845: l_dep_attr_tbl OE_GLOBALS.Number_Tbl_Type;
846: l_src_attr_tbl OE_GLOBALS.Number_Tbl_Type;
847: l_examined_attr_tbl OE_GLOBALS.Boolean_Tbl_Type;
848: l_out_attr_tbl OE_GLOBALS.Boolean_Tbl_Type;
849: --
842: IS
843: l_index NUMBER;
844: l_out_index NUMBER;
845: l_dep_attr_tbl OE_GLOBALS.Number_Tbl_Type;
846: l_src_attr_tbl OE_GLOBALS.Number_Tbl_Type;
847: l_examined_attr_tbl OE_GLOBALS.Boolean_Tbl_Type;
848: l_out_attr_tbl OE_GLOBALS.Boolean_Tbl_Type;
849: --
850: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
843: l_index NUMBER;
844: l_out_index NUMBER;
845: l_dep_attr_tbl OE_GLOBALS.Number_Tbl_Type;
846: l_src_attr_tbl OE_GLOBALS.Number_Tbl_Type;
847: l_examined_attr_tbl OE_GLOBALS.Boolean_Tbl_Type;
848: l_out_attr_tbl OE_GLOBALS.Boolean_Tbl_Type;
849: --
850: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
851: --
844: l_out_index NUMBER;
845: l_dep_attr_tbl OE_GLOBALS.Number_Tbl_Type;
846: l_src_attr_tbl OE_GLOBALS.Number_Tbl_Type;
847: l_examined_attr_tbl OE_GLOBALS.Boolean_Tbl_Type;
848: l_out_attr_tbl OE_GLOBALS.Boolean_Tbl_Type;
849: --
850: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
851: --
852: BEGIN