217: x_instrument_security_code := l_x_header_Payment_tbl(1).instrument_security_code; --R12 CC Encryption
218:
219: -- Load display out parameters if any
220:
221: l_Header_Payment_val_rec := OE_Header_Payment_Util.Get_Values
222: ( p_Header_Payment_rec => l_x_Header_Payment_tbl(1)
223: );
224: x_receipt_method := l_Header_Payment_val_rec.receipt_method;
225: x_pmt_collection_event_name := l_Header_Payment_val_rec.payment_collection_event_name;
565: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 CC encryption
566:
567: -- Load display out parameters if any
568:
569: l_Header_Payment_val_rec := OE_Header_PAYMENT_Util.Get_Values
570: ( p_Header_Payment_rec => l_x_Header_PAYMENT_tbl(1)
571: , p_old_Header_Payment_rec => l_Header_PAYMENT_rec
572: );
573:
948: oe_debug_pub.add(' p_attr_id is : ' || p_attr_id);
949: oe_debug_pub.add(' value is '||p_attr_value);
950: END IF;
951:
952: IF p_attr_id = OE_Header_Payment_Util.G_CHECK_NUMBER THEN
953: x_header_payment_tbl(1).check_number := p_attr_value;
954: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_APPROVAL_CODE THEN
955: x_header_payment_tbl(1).credit_card_approval_code := p_attr_value;
956: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
950: END IF;
951:
952: IF p_attr_id = OE_Header_Payment_Util.G_CHECK_NUMBER THEN
953: x_header_payment_tbl(1).check_number := p_attr_value;
954: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_APPROVAL_CODE THEN
955: x_header_payment_tbl(1).credit_card_approval_code := p_attr_value;
956: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
957: -- x_header_payment_tbl(1).credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
958: x_header_payment_tbl(1).credit_card_approval_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
952: IF p_attr_id = OE_Header_Payment_Util.G_CHECK_NUMBER THEN
953: x_header_payment_tbl(1).check_number := p_attr_value;
954: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_APPROVAL_CODE THEN
955: x_header_payment_tbl(1).credit_card_approval_code := p_attr_value;
956: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
957: -- x_header_payment_tbl(1).credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
958: x_header_payment_tbl(1).credit_card_approval_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
959: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_CODE THEN
960: x_header_payment_tbl(1).credit_card_code := p_attr_value;
955: x_header_payment_tbl(1).credit_card_approval_code := p_attr_value;
956: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_APPROVAL_DATE THEN
957: -- x_header_payment_tbl(1).credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
958: x_header_payment_tbl(1).credit_card_approval_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
959: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_CODE THEN
960: x_header_payment_tbl(1).credit_card_code := p_attr_value;
961: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
962: -- x_header_payment_tbl(1).credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
963: x_header_payment_tbl(1).credit_card_expiration_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
957: -- x_header_payment_tbl(1).credit_card_approval_date := TO_DATE(p_attr_value, l_date_format_mask);
958: x_header_payment_tbl(1).credit_card_approval_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
959: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_CODE THEN
960: x_header_payment_tbl(1).credit_card_code := p_attr_value;
961: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
962: -- x_header_payment_tbl(1).credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
963: x_header_payment_tbl(1).credit_card_expiration_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
964: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_HOLDER_NAME THEN
965: oe_debug_pub.add('New holder name'||p_attr_value);
960: x_header_payment_tbl(1).credit_card_code := p_attr_value;
961: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_EXPIRATION_DATE THEN
962: -- x_header_payment_tbl(1).credit_card_expiration_date := TO_DATE(p_attr_value, l_date_format_mask);
963: x_header_payment_tbl(1).credit_card_expiration_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
964: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_HOLDER_NAME THEN
965: oe_debug_pub.add('New holder name'||p_attr_value);
966: x_header_payment_tbl(1).credit_card_holder_name := p_attr_value;
967: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_NUMBER THEN
968: x_header_payment_tbl(1).credit_card_number := p_attr_value;
963: x_header_payment_tbl(1).credit_card_expiration_date := fnd_date.string_TO_DATE(p_attr_value, l_date_format_mask); --bug5402396
964: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_HOLDER_NAME THEN
965: oe_debug_pub.add('New holder name'||p_attr_value);
966: x_header_payment_tbl(1).credit_card_holder_name := p_attr_value;
967: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_NUMBER THEN
968: x_header_payment_tbl(1).credit_card_number := p_attr_value;
969: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_LEVEL_CODE THEN
970: x_header_payment_tbl(1).payment_level_code := p_attr_value;
971: ELSIF p_attr_id = OE_Header_Payment_Util.G_COMMITMENT_APPLIED_AMOUNT THEN
965: oe_debug_pub.add('New holder name'||p_attr_value);
966: x_header_payment_tbl(1).credit_card_holder_name := p_attr_value;
967: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_NUMBER THEN
968: x_header_payment_tbl(1).credit_card_number := p_attr_value;
969: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_LEVEL_CODE THEN
970: x_header_payment_tbl(1).payment_level_code := p_attr_value;
971: ELSIF p_attr_id = OE_Header_Payment_Util.G_COMMITMENT_APPLIED_AMOUNT THEN
972: x_header_payment_tbl(1).commitment_applied_amount := TO_NUMBER(p_attr_value);
973: ELSIF p_attr_id = OE_Header_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT THEN
967: ELSIF p_attr_id = OE_Header_Payment_Util.G_CREDIT_CARD_NUMBER THEN
968: x_header_payment_tbl(1).credit_card_number := p_attr_value;
969: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_LEVEL_CODE THEN
970: x_header_payment_tbl(1).payment_level_code := p_attr_value;
971: ELSIF p_attr_id = OE_Header_Payment_Util.G_COMMITMENT_APPLIED_AMOUNT THEN
972: x_header_payment_tbl(1).commitment_applied_amount := TO_NUMBER(p_attr_value);
973: ELSIF p_attr_id = OE_Header_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT THEN
974: x_header_payment_tbl(1).commitment_interfaced_amount := TO_NUMBER(p_attr_value);
975: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_NUMBER THEN
969: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_LEVEL_CODE THEN
970: x_header_payment_tbl(1).payment_level_code := p_attr_value;
971: ELSIF p_attr_id = OE_Header_Payment_Util.G_COMMITMENT_APPLIED_AMOUNT THEN
972: x_header_payment_tbl(1).commitment_applied_amount := TO_NUMBER(p_attr_value);
973: ELSIF p_attr_id = OE_Header_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT THEN
974: x_header_payment_tbl(1).commitment_interfaced_amount := TO_NUMBER(p_attr_value);
975: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_NUMBER THEN
976: x_header_payment_tbl(1).payment_number := TO_NUMBER(p_attr_value);
977: ELSIF p_attr_id = OE_Header_Payment_Util.G_HEADER THEN
971: ELSIF p_attr_id = OE_Header_Payment_Util.G_COMMITMENT_APPLIED_AMOUNT THEN
972: x_header_payment_tbl(1).commitment_applied_amount := TO_NUMBER(p_attr_value);
973: ELSIF p_attr_id = OE_Header_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT THEN
974: x_header_payment_tbl(1).commitment_interfaced_amount := TO_NUMBER(p_attr_value);
975: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_NUMBER THEN
976: x_header_payment_tbl(1).payment_number := TO_NUMBER(p_attr_value);
977: ELSIF p_attr_id = OE_Header_Payment_Util.G_HEADER THEN
978: x_header_payment_tbl(1).header_id := TO_NUMBER(p_attr_value);
979: ELSIF p_attr_id = OE_Header_Payment_Util.G_LINE THEN
973: ELSIF p_attr_id = OE_Header_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT THEN
974: x_header_payment_tbl(1).commitment_interfaced_amount := TO_NUMBER(p_attr_value);
975: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_NUMBER THEN
976: x_header_payment_tbl(1).payment_number := TO_NUMBER(p_attr_value);
977: ELSIF p_attr_id = OE_Header_Payment_Util.G_HEADER THEN
978: x_header_payment_tbl(1).header_id := TO_NUMBER(p_attr_value);
979: ELSIF p_attr_id = OE_Header_Payment_Util.G_LINE THEN
980: x_header_payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
981: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_PERCENTAGE THEN -- Added for bug 8478559
975: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_NUMBER THEN
976: x_header_payment_tbl(1).payment_number := TO_NUMBER(p_attr_value);
977: ELSIF p_attr_id = OE_Header_Payment_Util.G_HEADER THEN
978: x_header_payment_tbl(1).header_id := TO_NUMBER(p_attr_value);
979: ELSIF p_attr_id = OE_Header_Payment_Util.G_LINE THEN
980: x_header_payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
981: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_PERCENTAGE THEN -- Added for bug 8478559
982: x_header_payment_tbl(1).payment_percentage := TO_NUMBER(p_attr_value); -- Added for bug 8478559
983: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_AMOUNT THEN
977: ELSIF p_attr_id = OE_Header_Payment_Util.G_HEADER THEN
978: x_header_payment_tbl(1).header_id := TO_NUMBER(p_attr_value);
979: ELSIF p_attr_id = OE_Header_Payment_Util.G_LINE THEN
980: x_header_payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
981: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_PERCENTAGE THEN -- Added for bug 8478559
982: x_header_payment_tbl(1).payment_percentage := TO_NUMBER(p_attr_value); -- Added for bug 8478559
983: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_AMOUNT THEN
984: x_header_payment_tbl(1).payment_amount := TO_NUMBER(p_attr_value);
985: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_COLLECTION_EVENT THEN
979: ELSIF p_attr_id = OE_Header_Payment_Util.G_LINE THEN
980: x_header_payment_tbl(1).line_id := TO_NUMBER(p_attr_value);
981: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_PERCENTAGE THEN -- Added for bug 8478559
982: x_header_payment_tbl(1).payment_percentage := TO_NUMBER(p_attr_value); -- Added for bug 8478559
983: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_AMOUNT THEN
984: x_header_payment_tbl(1).payment_amount := TO_NUMBER(p_attr_value);
985: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_COLLECTION_EVENT THEN
986: x_header_payment_tbl(1).payment_collection_event := p_attr_value;
987: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_TRX_ID THEN
981: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_PERCENTAGE THEN -- Added for bug 8478559
982: x_header_payment_tbl(1).payment_percentage := TO_NUMBER(p_attr_value); -- Added for bug 8478559
983: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_AMOUNT THEN
984: x_header_payment_tbl(1).payment_amount := TO_NUMBER(p_attr_value);
985: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_COLLECTION_EVENT THEN
986: x_header_payment_tbl(1).payment_collection_event := p_attr_value;
987: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_TRX_ID THEN
988: x_header_payment_tbl(1).payment_trx_id := TO_NUMBER(p_attr_value);
989: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_TYPE_CODE THEN
983: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_AMOUNT THEN
984: x_header_payment_tbl(1).payment_amount := TO_NUMBER(p_attr_value);
985: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_COLLECTION_EVENT THEN
986: x_header_payment_tbl(1).payment_collection_event := p_attr_value;
987: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_TRX_ID THEN
988: x_header_payment_tbl(1).payment_trx_id := TO_NUMBER(p_attr_value);
989: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_TYPE_CODE THEN
990: x_header_payment_tbl(1).payment_type_code := p_attr_value;
991: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_SET_ID THEN
985: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_COLLECTION_EVENT THEN
986: x_header_payment_tbl(1).payment_collection_event := p_attr_value;
987: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_TRX_ID THEN
988: x_header_payment_tbl(1).payment_trx_id := TO_NUMBER(p_attr_value);
989: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_TYPE_CODE THEN
990: x_header_payment_tbl(1).payment_type_code := p_attr_value;
991: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_SET_ID THEN
992: x_header_payment_tbl(1).payment_set_id := TO_NUMBER(p_attr_value);
993: ELSIF p_attr_id = OE_Header_Payment_Util.G_PREPAID_AMOUNT THEN
987: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_TRX_ID THEN
988: x_header_payment_tbl(1).payment_trx_id := TO_NUMBER(p_attr_value);
989: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_TYPE_CODE THEN
990: x_header_payment_tbl(1).payment_type_code := p_attr_value;
991: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_SET_ID THEN
992: x_header_payment_tbl(1).payment_set_id := TO_NUMBER(p_attr_value);
993: ELSIF p_attr_id = OE_Header_Payment_Util.G_PREPAID_AMOUNT THEN
994: x_header_payment_tbl(1).prepaid_amount := TO_NUMBER(p_attr_value);
995: ELSIF p_attr_id = OE_Header_Payment_Util.G_RECEIPT_METHOD_ID THEN
989: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_TYPE_CODE THEN
990: x_header_payment_tbl(1).payment_type_code := p_attr_value;
991: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_SET_ID THEN
992: x_header_payment_tbl(1).payment_set_id := TO_NUMBER(p_attr_value);
993: ELSIF p_attr_id = OE_Header_Payment_Util.G_PREPAID_AMOUNT THEN
994: x_header_payment_tbl(1).prepaid_amount := TO_NUMBER(p_attr_value);
995: ELSIF p_attr_id = OE_Header_Payment_Util.G_RECEIPT_METHOD_ID THEN
996: x_header_payment_tbl(1).receipt_method_id := TO_NUMBER(p_attr_value);
997: ELSIF p_attr_id = OE_Header_Payment_Util.G_DEFER_PROCESSING_FLAG THEN
991: ELSIF p_attr_id = OE_Header_Payment_Util.G_PAYMENT_SET_ID THEN
992: x_header_payment_tbl(1).payment_set_id := TO_NUMBER(p_attr_value);
993: ELSIF p_attr_id = OE_Header_Payment_Util.G_PREPAID_AMOUNT THEN
994: x_header_payment_tbl(1).prepaid_amount := TO_NUMBER(p_attr_value);
995: ELSIF p_attr_id = OE_Header_Payment_Util.G_RECEIPT_METHOD_ID THEN
996: x_header_payment_tbl(1).receipt_method_id := TO_NUMBER(p_attr_value);
997: ELSIF p_attr_id = OE_Header_Payment_Util.G_DEFER_PROCESSING_FLAG THEN
998: x_header_payment_tbl(1).defer_payment_processing_flag := p_attr_value;
999: ELSIF p_attr_id = OE_Header_Payment_Util.G_TANGIBLE_ID THEN
993: ELSIF p_attr_id = OE_Header_Payment_Util.G_PREPAID_AMOUNT THEN
994: x_header_payment_tbl(1).prepaid_amount := TO_NUMBER(p_attr_value);
995: ELSIF p_attr_id = OE_Header_Payment_Util.G_RECEIPT_METHOD_ID THEN
996: x_header_payment_tbl(1).receipt_method_id := TO_NUMBER(p_attr_value);
997: ELSIF p_attr_id = OE_Header_Payment_Util.G_DEFER_PROCESSING_FLAG THEN
998: x_header_payment_tbl(1).defer_payment_processing_flag := p_attr_value;
999: ELSIF p_attr_id = OE_Header_Payment_Util.G_TANGIBLE_ID THEN
1000: x_header_payment_tbl(1).tangible_id := p_attr_value;
1001: ELSIF p_attr_id = OE_Header_Payment_Util.G_INSTRUMENT_SECURITY_CODE THEN --R12 CC encryption
995: ELSIF p_attr_id = OE_Header_Payment_Util.G_RECEIPT_METHOD_ID THEN
996: x_header_payment_tbl(1).receipt_method_id := TO_NUMBER(p_attr_value);
997: ELSIF p_attr_id = OE_Header_Payment_Util.G_DEFER_PROCESSING_FLAG THEN
998: x_header_payment_tbl(1).defer_payment_processing_flag := p_attr_value;
999: ELSIF p_attr_id = OE_Header_Payment_Util.G_TANGIBLE_ID THEN
1000: x_header_payment_tbl(1).tangible_id := p_attr_value;
1001: ELSIF p_attr_id = OE_Header_Payment_Util.G_INSTRUMENT_SECURITY_CODE THEN --R12 CC encryption
1002: x_header_payment_tbl(1).instrument_security_code := p_attr_value;
1003: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ID THEN --R12 CC encryption
997: ELSIF p_attr_id = OE_Header_Payment_Util.G_DEFER_PROCESSING_FLAG THEN
998: x_header_payment_tbl(1).defer_payment_processing_flag := p_attr_value;
999: ELSIF p_attr_id = OE_Header_Payment_Util.G_TANGIBLE_ID THEN
1000: x_header_payment_tbl(1).tangible_id := p_attr_value;
1001: ELSIF p_attr_id = OE_Header_Payment_Util.G_INSTRUMENT_SECURITY_CODE THEN --R12 CC encryption
1002: x_header_payment_tbl(1).instrument_security_code := p_attr_value;
1003: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ID THEN --R12 CC encryption
1004: x_header_payment_tbl(1).cc_instrument_id := p_attr_value;
1005: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
999: ELSIF p_attr_id = OE_Header_Payment_Util.G_TANGIBLE_ID THEN
1000: x_header_payment_tbl(1).tangible_id := p_attr_value;
1001: ELSIF p_attr_id = OE_Header_Payment_Util.G_INSTRUMENT_SECURITY_CODE THEN --R12 CC encryption
1002: x_header_payment_tbl(1).instrument_security_code := p_attr_value;
1003: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ID THEN --R12 CC encryption
1004: x_header_payment_tbl(1).cc_instrument_id := p_attr_value;
1005: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
1006: x_header_payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1007: ELSIF p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE1
1001: ELSIF p_attr_id = OE_Header_Payment_Util.G_INSTRUMENT_SECURITY_CODE THEN --R12 CC encryption
1002: x_header_payment_tbl(1).instrument_security_code := p_attr_value;
1003: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ID THEN --R12 CC encryption
1004: x_header_payment_tbl(1).cc_instrument_id := p_attr_value;
1005: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
1006: x_header_payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1007: ELSIF p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE1
1008: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE2
1009: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE3
1003: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ID THEN --R12 CC encryption
1004: x_header_payment_tbl(1).cc_instrument_id := p_attr_value;
1005: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
1006: x_header_payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1007: ELSIF p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE1
1008: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE2
1009: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE3
1010: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE4
1011: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE5
1004: x_header_payment_tbl(1).cc_instrument_id := p_attr_value;
1005: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
1006: x_header_payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1007: ELSIF p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE1
1008: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE2
1009: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE3
1010: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE4
1011: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE5
1012: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE6
1005: ELSIF p_attr_id = OE_Header_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption
1006: x_header_payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1007: ELSIF p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE1
1008: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE2
1009: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE3
1010: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE4
1011: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE5
1012: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE6
1013: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE7
1006: x_header_payment_tbl(1).cc_instrument_assignment_id := p_attr_value;
1007: ELSIF p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE1
1008: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE2
1009: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE3
1010: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE4
1011: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE5
1012: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE6
1013: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE7
1014: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE8
1007: ELSIF p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE1
1008: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE2
1009: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE3
1010: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE4
1011: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE5
1012: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE6
1013: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE7
1014: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE8
1015: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE9
1008: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE2
1009: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE3
1010: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE4
1011: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE5
1012: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE6
1013: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE7
1014: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE8
1015: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE9
1016: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE10
1009: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE3
1010: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE4
1011: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE5
1012: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE6
1013: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE7
1014: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE8
1015: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE9
1016: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE10
1017: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE11
1010: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE4
1011: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE5
1012: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE6
1013: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE7
1014: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE8
1015: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE9
1016: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE10
1017: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE11
1018: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE12
1011: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE5
1012: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE6
1013: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE7
1014: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE8
1015: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE9
1016: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE10
1017: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE11
1018: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE12
1019: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE13
1012: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE6
1013: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE7
1014: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE8
1015: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE9
1016: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE10
1017: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE11
1018: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE12
1019: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE13
1020: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE14
1013: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE7
1014: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE8
1015: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE9
1016: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE10
1017: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE11
1018: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE12
1019: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE13
1020: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE14
1021: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE15
1014: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE8
1015: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE9
1016: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE10
1017: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE11
1018: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE12
1019: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE13
1020: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE14
1021: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE15
1022: OR p_attr_id = OE_Header_Payment_Util.G_CONTEXT
1015: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE9
1016: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE10
1017: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE11
1018: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE12
1019: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE13
1020: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE14
1021: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE15
1022: OR p_attr_id = OE_Header_Payment_Util.G_CONTEXT
1023: THEN
1016: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE10
1017: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE11
1018: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE12
1019: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE13
1020: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE14
1021: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE15
1022: OR p_attr_id = OE_Header_Payment_Util.G_CONTEXT
1023: THEN
1024:
1017: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE11
1018: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE12
1019: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE13
1020: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE14
1021: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE15
1022: OR p_attr_id = OE_Header_Payment_Util.G_CONTEXT
1023: THEN
1024:
1025: x_header_payment_tbl(1).attribute1 := p_attribute1;
1018: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE12
1019: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE13
1020: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE14
1021: OR p_attr_id = OE_Header_Payment_Util.G_ATTRIBUTE15
1022: OR p_attr_id = OE_Header_Payment_Util.G_CONTEXT
1023: THEN
1024:
1025: x_header_payment_tbl(1).attribute1 := p_attribute1;
1026: x_header_payment_tbl(1).attribute2 := p_attribute2;
1615: l_x_Header_Payment_rec.lock_control := p_lock_control;
1616:
1617: -- Call oe_headers_Payments_util.lock_row instead of OE_Order_PVT.Lock_order
1618:
1619: OE_Header_Payment_Util.Lock_Row
1620: ( x_return_status => l_return_status
1621: , p_x_header_Payment_rec => l_x_header_payment_rec );
1622: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1623:
1723: THEN
1724:
1725: -- Query row from DB
1726:
1727: OE_Header_Payment_Util.Query_Row
1728: ( p_payment_number => p_payment_number
1729: , p_header_id => p_header_id
1730: , x_header_Payment_rec => g_Header_Payment_rec
1731: );