DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE_PAYMENT dependencies on OE_LINE_PAYMENT_UTIL

Line 238: l_Line_Payment_val_rec := OE_Line_Payment_Util.Get_Values

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;

Line 586: l_Line_Payment_val_rec := OE_Line_PAYMENT_Util.Get_Values

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:

Line 965: IF p_attr_id = OE_Line_Payment_Util.G_CHECK_NUMBER THEN

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

Line 967: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_APPROVAL_CODE 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

Line 969: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_APPROVAL_DATE THEN

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;

Line 972: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_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;
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

Line 974: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_EXPIRATION_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
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;

Line 977: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_HOLDER_NAME 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;
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

Line 979: ELSIF p_attr_id = OE_Line_Payment_Util.G_CREDIT_CARD_NUMBER 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

Line 981: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_LEVEL_CODE 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

Line 983: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_APPLIED_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

Line 985: ELSIF p_attr_id = OE_Line_Payment_Util.G_COMMITMENT_INTERFACED_AMOUNT 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

Line 987: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_NUMBER 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

Line 989: 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

Line 991: ELSIF p_attr_id = OE_Line_Payment_Util.G_LINE 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

Line 993: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_AMOUNT 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

Line 995: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_COLLECTION_EVENT 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

Line 997: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TRX_ID 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

Line 999: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_TYPE_CODE 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

Line 1001: ELSIF p_attr_id = OE_Line_Payment_Util.G_PAYMENT_SET_ID 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

Line 1003: ELSIF p_attr_id = OE_Line_Payment_Util.G_PREPAID_AMOUNT 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

Line 1005: ELSIF p_attr_id = OE_Line_Payment_Util.G_RECEIPT_METHOD_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

Line 1007: ELSIF p_attr_id = OE_Line_Payment_Util.G_TANGIBLE_ID THEN

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

Line 1009: ELSIF p_attr_id = OE_Line_Payment_Util.G_INSTRUMENT_SECURITY_CODE 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

Line 1011: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_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

Line 1013: ELSIF p_attr_id = OE_Line_Payment_Util.G_CC_INSTRUMENT_ASSIGNMENT_ID THEN --R12 CC encryption

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

Line 1015: ELSIF p_attr_id = OE_LINE_PAYMENT_UTIL.G_DEFER_PROCESSING_FLAG THEN

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

Line 1017: ELSIF p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE1

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

Line 1018: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE2

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

Line 1019: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE3

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

Line 1020: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE4

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

Line 1021: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE5

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

Line 1022: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE6

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

Line 1023: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE7

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

Line 1024: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE8

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

Line 1025: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE9

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

Line 1026: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE10

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

Line 1027: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE11

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

Line 1028: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE12

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

Line 1029: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE13

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

Line 1030: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE14

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:

Line 1031: OR p_attr_id = OE_Line_Payment_Util.G_ATTRIBUTE15

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;

Line 1032: OR p_attr_id = OE_Line_Payment_Util.G_CONTEXT

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;

Line 1637: OE_Line_Payment_Util.Lock_Row

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:

Line 1745: OE_Line_Payment_Util.Query_Row

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