234: x_instrument_security_code := l_x_line_Payment_tbl(1).instrument_security_code; --R12 CC Encryption
235:
236: -- Load display out parameters if any
237:
238: l_Line_Payment_val_rec := OE_Line_Payment_Util.Get_Values
239: ( p_Line_Payment_rec => l_x_Line_Payment_tbl(1)
240: );
241: x_receipt_method := l_Line_Payment_val_rec.receipt_method;
242: x_pmt_collection_event_name := l_Line_Payment_val_rec.payment_collection_event_name;
582: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 Cc encryption
583:
584: -- Load display out parameters if any
585:
586: l_Line_Payment_val_rec := OE_Line_PAYMENT_Util.Get_Values
587: ( p_Line_Payment_rec => l_x_Line_PAYMENT_tbl(1)
588: , p_old_Line_Payment_rec => l_Line_PAYMENT_rec
589: );
590:
961: oe_debug_pub.add(' p_attr_id is : ' || p_attr_id);
962: oe_debug_pub.add(' value is '||p_attr_value);
963: END IF;
964:
965: IF p_attr_id = OE_Line_Payment_Util.G_CHECK_NUMBER THEN
966: x_line_payment_tbl(1).check_number := p_attr_value;
967: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_APPROVAL_CODE THEN
968: x_line_payment_tbl(1).credit_card_approval_code := p_attr_value;
969: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
963: END IF;
964:
965: IF p_attr_id = OE_Line_Payment_Util.G_CHECK_NUMBER THEN
966: x_line_payment_tbl(1).check_number := p_attr_value;
967: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_APPROVAL_CODE THEN
968: x_line_payment_tbl(1).credit_card_approval_code := p_attr_value;
969: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
970: -- x_line_payment_tbl(1).credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
971: x_line_payment_tbl(1).credit_card_approval_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
965: IF p_attr_id = OE_Line_Payment_Util.G_CHECK_NUMBER THEN
966: x_line_payment_tbl(1).check_number := p_attr_value;
967: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_APPROVAL_CODE THEN
968: x_line_payment_tbl(1).credit_card_approval_code := p_attr_value;
969: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
970: -- x_line_payment_tbl(1).credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
971: x_line_payment_tbl(1).credit_card_approval_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
972: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_CODE THEN
973: x_line_payment_tbl(1).credit_card_code := p_attr_value;
968: x_line_payment_tbl(1).credit_card_approval_code := p_attr_value;
969: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
970: -- x_line_payment_tbl(1).credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
971: x_line_payment_tbl(1).credit_card_approval_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
972: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_CODE THEN
973: x_line_payment_tbl(1).credit_card_code := p_attr_value;
974: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
975: -- x_line_payment_tbl(1).credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
976: x_line_payment_tbl(1).credit_card_expiration_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
970: -- x_line_payment_tbl(1).credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
971: x_line_payment_tbl(1).credit_card_approval_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
972: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_CODE THEN
973: x_line_payment_tbl(1).credit_card_code := p_attr_value;
974: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
975: -- x_line_payment_tbl(1).credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
976: x_line_payment_tbl(1).credit_card_expiration_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
977: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_HOLDER_NAME THEN
978: x_line_payment_tbl(1).credit_card_holder_name := p_attr_value;
973: x_line_payment_tbl(1).credit_card_code := p_attr_value;
974: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
975: -- x_line_payment_tbl(1).credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
976: x_line_payment_tbl(1).credit_card_expiration_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
977: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_HOLDER_NAME THEN
978: x_line_payment_tbl(1).credit_card_holder_name := p_attr_value;
979: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_NUMBER THEN
980: x_line_payment_tbl(1).credit_card_number := p_attr_value;
981: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_LEVEL_CODE THEN
975: -- x_line_payment_tbl(1).credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
976: x_line_payment_tbl(1).credit_card_expiration_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
977: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_HOLDER_NAME THEN
978: x_line_payment_tbl(1).credit_card_holder_name := p_attr_value;
979: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_NUMBER THEN
980: x_line_payment_tbl(1).credit_card_number := p_attr_value;
981: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_LEVEL_CODE THEN
982: x_line_payment_tbl(1).payment_level_code := p_attr_value;
983: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_APPLIED_AMOUNT THEN
977: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_HOLDER_NAME THEN
978: x_line_payment_tbl(1).credit_card_holder_name := p_attr_value;
979: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_NUMBER THEN
980: x_line_payment_tbl(1).credit_card_number := p_attr_value;
981: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_LEVEL_CODE THEN
982: x_line_payment_tbl(1).payment_level_code := p_attr_value;
983: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_APPLIED_AMOUNT THEN
984: x_line_Payment_tbl(1).commitment_applied_amount := TO_NUMBER(p_attr_value);
985: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT THEN
979: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_NUMBER THEN
980: x_line_payment_tbl(1).credit_card_number := p_attr_value;
981: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_LEVEL_CODE THEN
982: x_line_payment_tbl(1).payment_level_code := p_attr_value;
983: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_APPLIED_AMOUNT THEN
984: x_line_Payment_tbl(1).commitment_applied_amount := TO_NUMBER(p_attr_value);
985: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT THEN
986: x_line_Payment_tbl(1).commitment_interfaced_amount := TO_NUMBER(p_attr_value);
987: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_NUMBER THEN
981: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_LEVEL_CODE THEN
982: x_line_payment_tbl(1).payment_level_code := p_attr_value;
983: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_APPLIED_AMOUNT THEN
984: x_line_Payment_tbl(1).commitment_applied_amount := TO_NUMBER(p_attr_value);
985: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT THEN
986: x_line_Payment_tbl(1).commitment_interfaced_amount := TO_NUMBER(p_attr_value);
987: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_NUMBER THEN
988: x_line_Payment_tbl(1).payment_number := TO_NUMBER(p_attr_value);
989: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE THEN
983: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_APPLIED_AMOUNT THEN
984: x_line_Payment_tbl(1).commitment_applied_amount := TO_NUMBER(p_attr_value);
985: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT THEN
986: x_line_Payment_tbl(1).commitment_interfaced_amount := TO_NUMBER(p_attr_value);
987: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_NUMBER THEN
988: x_line_Payment_tbl(1).payment_number := TO_NUMBER(p_attr_value);
989: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE THEN
990: x_line_Payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
991: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE THEN
985: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT THEN
986: x_line_Payment_tbl(1).commitment_interfaced_amount := TO_NUMBER(p_attr_value);
987: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_NUMBER THEN
988: x_line_Payment_tbl(1).payment_number := TO_NUMBER(p_attr_value);
989: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE THEN
990: x_line_Payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
991: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE THEN
992: x_line_Payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
993: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_AMOUNT THEN
987: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_NUMBER THEN
988: x_line_Payment_tbl(1).payment_number := TO_NUMBER(p_attr_value);
989: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE THEN
990: x_line_Payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
991: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE THEN
992: x_line_Payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
993: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_AMOUNT THEN
994: x_line_Payment_tbl(1).payment_amount := TO_NUMBER(p_attr_value);
995: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_COLLECTION_EVENT THEN
989: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE THEN
990: x_line_Payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
991: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE THEN
992: x_line_Payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
993: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_AMOUNT THEN
994: x_line_Payment_tbl(1).payment_amount := TO_NUMBER(p_attr_value);
995: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_COLLECTION_EVENT THEN
996: x_line_Payment_tbl(1).payment_collection_event := p_attr_value;
997: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TRX_ID THEN
991: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE THEN
992: x_line_Payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
993: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_AMOUNT THEN
994: x_line_Payment_tbl(1).payment_amount := TO_NUMBER(p_attr_value);
995: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_COLLECTION_EVENT THEN
996: x_line_Payment_tbl(1).payment_collection_event := p_attr_value;
997: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TRX_ID THEN
998: x_line_Payment_tbl(1).payment_trx_id := TO_NUMBER(p_attr_value);
999: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TYPE_CODE THEN
993: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_AMOUNT THEN
994: x_line_Payment_tbl(1).payment_amount := TO_NUMBER(p_attr_value);
995: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_COLLECTION_EVENT THEN
996: x_line_Payment_tbl(1).payment_collection_event := p_attr_value;
997: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TRX_ID THEN
998: x_line_Payment_tbl(1).payment_trx_id := TO_NUMBER(p_attr_value);
999: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TYPE_CODE THEN
1000: x_line_Payment_tbl(1).payment_type_code := p_attr_value;
1001: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_SET_ID THEN
995: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_COLLECTION_EVENT THEN
996: x_line_Payment_tbl(1).payment_collection_event := p_attr_value;
997: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TRX_ID THEN
998: x_line_Payment_tbl(1).payment_trx_id := TO_NUMBER(p_attr_value);
999: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TYPE_CODE THEN
1000: x_line_Payment_tbl(1).payment_type_code := p_attr_value;
1001: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_SET_ID THEN
1002: x_line_Payment_tbl(1).payment_set_id := TO_NUMBER(p_attr_value);
1003: ELSIF p_attr_id = OE_Line_Payment_Util.G_PREPAID_AMOUNT THEN
997: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TRX_ID THEN
998: x_line_Payment_tbl(1).payment_trx_id := TO_NUMBER(p_attr_value);
999: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TYPE_CODE THEN
1000: x_line_Payment_tbl(1).payment_type_code := p_attr_value;
1001: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_SET_ID THEN
1002: x_line_Payment_tbl(1).payment_set_id := TO_NUMBER(p_attr_value);
1003: ELSIF p_attr_id = OE_Line_Payment_Util.G_PREPAID_AMOUNT THEN
1004: x_line_Payment_tbl(1).prepaid_amount := TO_NUMBER(p_attr_value);
1005: ELSIF p_attr_id = OE_Line_Payment_Util.G_RECEIPT_METHOD_ID THEN
999: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TYPE_CODE THEN
1000: x_line_Payment_tbl(1).payment_type_code := p_attr_value;
1001: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_SET_ID THEN
1002: x_line_Payment_tbl(1).payment_set_id := TO_NUMBER(p_attr_value);
1003: ELSIF p_attr_id = OE_Line_Payment_Util.G_PREPAID_AMOUNT THEN
1004: x_line_Payment_tbl(1).prepaid_amount := TO_NUMBER(p_attr_value);
1005: ELSIF p_attr_id = OE_Line_Payment_Util.G_RECEIPT_METHOD_ID THEN
1006: x_line_Payment_tbl(1).receipt_method_id := TO_NUMBER(p_attr_value);
1007: ELSIF p_attr_id = OE_Line_Payment_Util.G_TANGIBLE_ID THEN
1001: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_SET_ID THEN
1002: x_line_Payment_tbl(1).payment_set_id := TO_NUMBER(p_attr_value);
1003: ELSIF p_attr_id = OE_Line_Payment_Util.G_PREPAID_AMOUNT THEN
1004: x_line_Payment_tbl(1).prepaid_amount := TO_NUMBER(p_attr_value);
1005: ELSIF p_attr_id = OE_Line_Payment_Util.G_RECEIPT_METHOD_ID THEN
1006: x_line_Payment_tbl(1).receipt_method_id := TO_NUMBER(p_attr_value);
1007: ELSIF p_attr_id = OE_Line_Payment_Util.G_TANGIBLE_ID THEN
1008: x_line_Payment_tbl(1).tangible_id := p_attr_value;
1009: ELSIF p_attr_id = OE_Line_Payment_Util.G_INSTRUMENT_SECURITY_CODE THEN --R12 Cc encryption
1003: ELSIF p_attr_id = OE_Line_Payment_Util.G_PREPAID_AMOUNT THEN
1004: x_line_Payment_tbl(1).prepaid_amount := TO_NUMBER(p_attr_value);
1005: ELSIF p_attr_id = OE_Line_Payment_Util.G_RECEIPT_METHOD_ID THEN
1006: x_line_Payment_tbl(1).receipt_method_id := TO_NUMBER(p_attr_value);
1007: ELSIF p_attr_id = OE_Line_Payment_Util.G_TANGIBLE_ID THEN
1008: x_line_Payment_tbl(1).tangible_id := p_attr_value;
1009: ELSIF p_attr_id = OE_Line_Payment_Util.G_INSTRUMENT_SECURITY_CODE THEN --R12 Cc encryption
1010: x_line_Payment_tbl(1).instrument_security_code := p_attr_value;
1011: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ID THEN --R12 CC encryption
1005: ELSIF p_attr_id = OE_Line_Payment_Util.G_RECEIPT_METHOD_ID THEN
1006: x_line_Payment_tbl(1).receipt_method_id := TO_NUMBER(p_attr_value);
1007: ELSIF p_attr_id = OE_Line_Payment_Util.G_TANGIBLE_ID THEN
1008: x_line_Payment_tbl(1).tangible_id := p_attr_value;
1009: ELSIF p_attr_id = OE_Line_Payment_Util.G_INSTRUMENT_SECURITY_CODE THEN --R12 Cc encryption
1010: x_line_Payment_tbl(1).instrument_security_code := p_attr_value;
1011: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ID THEN --R12 CC encryption
1012: x_line_Payment_tbl(1).cc_instrument_id := p_attr_value;
1013: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
1007: ELSIF p_attr_id = OE_Line_Payment_Util.G_TANGIBLE_ID THEN
1008: x_line_Payment_tbl(1).tangible_id := p_attr_value;
1009: ELSIF p_attr_id = OE_Line_Payment_Util.G_INSTRUMENT_SECURITY_CODE THEN --R12 Cc encryption
1010: x_line_Payment_tbl(1).instrument_security_code := p_attr_value;
1011: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ID THEN --R12 CC encryption
1012: x_line_Payment_tbl(1).cc_instrument_id := p_attr_value;
1013: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
1014: x_line_Payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1015: ELSIF p_attr_id = OE_LINE_PAYMENT_UTIL.G_DEFER_PROCESSING_FLAG THEN
1009: ELSIF p_attr_id = OE_Line_Payment_Util.G_INSTRUMENT_SECURITY_CODE THEN --R12 Cc encryption
1010: x_line_Payment_tbl(1).instrument_security_code := p_attr_value;
1011: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ID THEN --R12 CC encryption
1012: x_line_Payment_tbl(1).cc_instrument_id := p_attr_value;
1013: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
1014: x_line_Payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1015: ELSIF p_attr_id = OE_LINE_PAYMENT_UTIL.G_DEFER_PROCESSING_FLAG THEN
1016: x_line_Payment_tbl(1).defer_payment_processing_flag := p_attr_value;
1017: ELSIF p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE1
1011: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ID THEN --R12 CC encryption
1012: x_line_Payment_tbl(1).cc_instrument_id := p_attr_value;
1013: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
1014: x_line_Payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1015: ELSIF p_attr_id = OE_LINE_PAYMENT_UTIL.G_DEFER_PROCESSING_FLAG THEN
1016: x_line_Payment_tbl(1).defer_payment_processing_flag := p_attr_value;
1017: ELSIF p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE1
1018: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE2
1019: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE3
1013: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
1014: x_line_Payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1015: ELSIF p_attr_id = OE_LINE_PAYMENT_UTIL.G_DEFER_PROCESSING_FLAG THEN
1016: x_line_Payment_tbl(1).defer_payment_processing_flag := p_attr_value;
1017: ELSIF p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE1
1018: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE2
1019: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE3
1020: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE4
1021: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE5
1014: x_line_Payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1015: ELSIF p_attr_id = OE_LINE_PAYMENT_UTIL.G_DEFER_PROCESSING_FLAG THEN
1016: x_line_Payment_tbl(1).defer_payment_processing_flag := p_attr_value;
1017: ELSIF p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE1
1018: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE2
1019: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE3
1020: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE4
1021: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE5
1022: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE6
1015: ELSIF p_attr_id = OE_LINE_PAYMENT_UTIL.G_DEFER_PROCESSING_FLAG THEN
1016: x_line_Payment_tbl(1).defer_payment_processing_flag := p_attr_value;
1017: ELSIF p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE1
1018: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE2
1019: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE3
1020: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE4
1021: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE5
1022: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE6
1023: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE7
1016: x_line_Payment_tbl(1).defer_payment_processing_flag := p_attr_value;
1017: ELSIF p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE1
1018: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE2
1019: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE3
1020: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE4
1021: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE5
1022: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE6
1023: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE7
1024: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE8
1017: ELSIF p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE1
1018: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE2
1019: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE3
1020: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE4
1021: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE5
1022: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE6
1023: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE7
1024: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE8
1025: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE9
1018: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE2
1019: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE3
1020: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE4
1021: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE5
1022: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE6
1023: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE7
1024: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE8
1025: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE9
1026: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE10
1019: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE3
1020: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE4
1021: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE5
1022: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE6
1023: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE7
1024: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE8
1025: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE9
1026: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE10
1027: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE11
1020: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE4
1021: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE5
1022: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE6
1023: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE7
1024: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE8
1025: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE9
1026: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE10
1027: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE11
1028: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE12
1021: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE5
1022: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE6
1023: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE7
1024: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE8
1025: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE9
1026: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE10
1027: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE11
1028: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE12
1029: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE13
1022: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE6
1023: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE7
1024: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE8
1025: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE9
1026: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE10
1027: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE11
1028: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE12
1029: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE13
1030: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE14
1023: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE7
1024: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE8
1025: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE9
1026: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE10
1027: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE11
1028: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE12
1029: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE13
1030: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE14
1031: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE15
1024: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE8
1025: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE9
1026: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE10
1027: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE11
1028: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE12
1029: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE13
1030: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE14
1031: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE15
1032: OR p_attr_id = OE_Line_Payment_Util.G_CONTEXT
1025: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE9
1026: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE10
1027: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE11
1028: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE12
1029: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE13
1030: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE14
1031: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE15
1032: OR p_attr_id = OE_Line_Payment_Util.G_CONTEXT
1033: THEN
1026: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE10
1027: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE11
1028: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE12
1029: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE13
1030: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE14
1031: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE15
1032: OR p_attr_id = OE_Line_Payment_Util.G_CONTEXT
1033: THEN
1034:
1027: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE11
1028: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE12
1029: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE13
1030: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE14
1031: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE15
1032: OR p_attr_id = OE_Line_Payment_Util.G_CONTEXT
1033: THEN
1034:
1035: x_line_Payment_tbl(1).attribute1 := p_attribute1;
1028: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE12
1029: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE13
1030: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE14
1031: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE15
1032: OR p_attr_id = OE_Line_Payment_Util.G_CONTEXT
1033: THEN
1034:
1035: x_line_Payment_tbl(1).attribute1 := p_attribute1;
1036: x_line_Payment_tbl(1).attribute2 := p_attribute2;
1633: l_x_Line_Payment_rec.lock_control := p_lock_control;
1634:
1635: -- Call oe_lines_Payments_util.lock_row instead of OE_Order_PVT.Lock_order
1636:
1637: OE_Line_Payment_Util.Lock_Row
1638: ( x_return_status => l_return_status
1639: , p_x_line_Payment_rec => l_x_line_payment_rec );
1640: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1641:
1741: OR p_line_id <> NVL(g_Line_Payment_rec.line_id,-1)
1742: THEN
1743:
1744: -- Query row from DB
1745: OE_Line_Payment_Util.Query_Row
1746: ( p_payment_number => p_payment_number
1747: , p_line_id => p_line_id
1748: , p_header_id => p_header_id
1749: , x_line_Payment_rec => g_Line_Payment_rec