eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_CM_REQUESTS

Line 1020: l_line_credit_flag ra_cm_requests.line_credits_flag%type;

1016: l_api_version NUMBER := 1.0;
1017: l_api_name VARCHAR2(50) := 'create_cm_on_emd_deposit';
1018: l_progress NUMBER;
1019: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1020: l_line_credit_flag ra_cm_requests.line_credits_flag%type;
1021: l_line_amount NUMBER := NULL;
1022: l_tax_amount NUMBER := NULL;
1023: l_freight_amount NUMBER := NULL;
1024: l_cm_reason_code ra_cm_requests.cm_reason_code%TYPE;

Line 1024: l_cm_reason_code ra_cm_requests.cm_reason_code%TYPE;

1020: l_line_credit_flag ra_cm_requests.line_credits_flag%type;
1021: l_line_amount NUMBER := NULL;
1022: l_tax_amount NUMBER := NULL;
1023: l_freight_amount NUMBER := NULL;
1024: l_cm_reason_code ra_cm_requests.cm_reason_code%TYPE;
1025: l_comments ra_cm_requests.comments%TYPE DEFAULT NULL ;
1026: l_orig_trx_number ra_cm_requests.orig_trx_number%TYPE DEFAULT NULL;
1027: l_tax_ex_cert_num ra_cm_requests.tax_ex_cert_num%TYPE DEFAULT NULL;
1028: l_request_url ra_cm_requests.url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';

Line 1025: l_comments ra_cm_requests.comments%TYPE DEFAULT NULL ;

1021: l_line_amount NUMBER := NULL;
1022: l_tax_amount NUMBER := NULL;
1023: l_freight_amount NUMBER := NULL;
1024: l_cm_reason_code ra_cm_requests.cm_reason_code%TYPE;
1025: l_comments ra_cm_requests.comments%TYPE DEFAULT NULL ;
1026: l_orig_trx_number ra_cm_requests.orig_trx_number%TYPE DEFAULT NULL;
1027: l_tax_ex_cert_num ra_cm_requests.tax_ex_cert_num%TYPE DEFAULT NULL;
1028: l_request_url ra_cm_requests.url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1029: l_transaction_url ra_cm_requests.transaction_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';

Line 1026: l_orig_trx_number ra_cm_requests.orig_trx_number%TYPE DEFAULT NULL;

1022: l_tax_amount NUMBER := NULL;
1023: l_freight_amount NUMBER := NULL;
1024: l_cm_reason_code ra_cm_requests.cm_reason_code%TYPE;
1025: l_comments ra_cm_requests.comments%TYPE DEFAULT NULL ;
1026: l_orig_trx_number ra_cm_requests.orig_trx_number%TYPE DEFAULT NULL;
1027: l_tax_ex_cert_num ra_cm_requests.tax_ex_cert_num%TYPE DEFAULT NULL;
1028: l_request_url ra_cm_requests.url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1029: l_transaction_url ra_cm_requests.transaction_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1030: l_trans_act_url ra_cm_requests.activities_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';

Line 1027: l_tax_ex_cert_num ra_cm_requests.tax_ex_cert_num%TYPE DEFAULT NULL;

1023: l_freight_amount NUMBER := NULL;
1024: l_cm_reason_code ra_cm_requests.cm_reason_code%TYPE;
1025: l_comments ra_cm_requests.comments%TYPE DEFAULT NULL ;
1026: l_orig_trx_number ra_cm_requests.orig_trx_number%TYPE DEFAULT NULL;
1027: l_tax_ex_cert_num ra_cm_requests.tax_ex_cert_num%TYPE DEFAULT NULL;
1028: l_request_url ra_cm_requests.url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1029: l_transaction_url ra_cm_requests.transaction_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1030: l_trans_act_url ra_cm_requests.activities_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1031: l_cm_line_tbl arw_cmreq_cover.Cm_Line_Tbl_Type_Cover := ar_credit_memo_api_pub.cm_line_tbl_type_cover ;

Line 1028: l_request_url ra_cm_requests.url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';

1024: l_cm_reason_code ra_cm_requests.cm_reason_code%TYPE;
1025: l_comments ra_cm_requests.comments%TYPE DEFAULT NULL ;
1026: l_orig_trx_number ra_cm_requests.orig_trx_number%TYPE DEFAULT NULL;
1027: l_tax_ex_cert_num ra_cm_requests.tax_ex_cert_num%TYPE DEFAULT NULL;
1028: l_request_url ra_cm_requests.url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1029: l_transaction_url ra_cm_requests.transaction_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1030: l_trans_act_url ra_cm_requests.activities_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1031: l_cm_line_tbl arw_cmreq_cover.Cm_Line_Tbl_Type_Cover := ar_credit_memo_api_pub.cm_line_tbl_type_cover ;
1032: l_skip_workflow_flag VARCHAR2(1) DEFAULT 'N';

Line 1029: l_transaction_url ra_cm_requests.transaction_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';

1025: l_comments ra_cm_requests.comments%TYPE DEFAULT NULL ;
1026: l_orig_trx_number ra_cm_requests.orig_trx_number%TYPE DEFAULT NULL;
1027: l_tax_ex_cert_num ra_cm_requests.tax_ex_cert_num%TYPE DEFAULT NULL;
1028: l_request_url ra_cm_requests.url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1029: l_transaction_url ra_cm_requests.transaction_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1030: l_trans_act_url ra_cm_requests.activities_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1031: l_cm_line_tbl arw_cmreq_cover.Cm_Line_Tbl_Type_Cover := ar_credit_memo_api_pub.cm_line_tbl_type_cover ;
1032: l_skip_workflow_flag VARCHAR2(1) DEFAULT 'N';
1033: l_credit_method_installments ra_customer_trx.credit_method_for_installments%type DEFAULT NULL;

Line 1030: l_trans_act_url ra_cm_requests.activities_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';

1026: l_orig_trx_number ra_cm_requests.orig_trx_number%TYPE DEFAULT NULL;
1027: l_tax_ex_cert_num ra_cm_requests.tax_ex_cert_num%TYPE DEFAULT NULL;
1028: l_request_url ra_cm_requests.url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1029: l_transaction_url ra_cm_requests.transaction_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1030: l_trans_act_url ra_cm_requests.activities_url%TYPE := 'AR_CREDIT_MEMO_API_PUB.print_default_page';
1031: l_cm_line_tbl arw_cmreq_cover.Cm_Line_Tbl_Type_Cover := ar_credit_memo_api_pub.cm_line_tbl_type_cover ;
1032: l_skip_workflow_flag VARCHAR2(1) DEFAULT 'N';
1033: l_credit_method_installments ra_customer_trx.credit_method_for_installments%type DEFAULT NULL;
1034: l_credit_method_rules ra_customer_trx.credit_method_for_rules%type DEFAULT NULL;

Line 1037: x_request_id ra_cm_requests.request_id%type;

1033: l_credit_method_installments ra_customer_trx.credit_method_for_installments%type DEFAULT NULL;
1034: l_credit_method_rules ra_customer_trx.credit_method_for_rules%type DEFAULT NULL;
1035: l_batch_source_name ra_batch_sources.NAME%TYPE DEFAULT NULL;
1036: l_org_id NUMBER DEFAULT NULL;
1037: x_request_id ra_cm_requests.request_id%type;
1038: l_attribute_rec arw_cmreq_cover.pq_attribute_rec_type DEFAULT ar_credit_memo_api_pub.attribute_rec_const;
1039: l_interface_attribute_rec arw_cmreq_cover.pq_interface_rec_type DEFAULT ar_credit_memo_api_pub.interface_rec_const;
1040: l_global_attribute_rec arw_cmreq_cover.pq_global_attribute_rec_type DEFAULT ar_credit_memo_api_pub.global_attribute_rec_const;
1041: l_dispute_date DATE DEFAULT NULL;

Line 1044: l_request_id ra_cm_requests.request_id%TYPE;

1040: l_global_attribute_rec arw_cmreq_cover.pq_global_attribute_rec_type DEFAULT ar_credit_memo_api_pub.global_attribute_rec_const;
1041: l_dispute_date DATE DEFAULT NULL;
1042:
1043: --Request status parameters
1044: l_request_id ra_cm_requests.request_id%TYPE;
1045: x_status_meaning VARCHAR2(30);
1046: x_reason_meaning VARCHAR2(30);
1047: x_customer_trx_id ra_cm_requests.customer_trx_id%TYPE;
1048: x_cm_customer_trx_id ra_cm_requests.cm_customer_trx_id%TYPE;

Line 1047: x_customer_trx_id ra_cm_requests.customer_trx_id%TYPE;

1043: --Request status parameters
1044: l_request_id ra_cm_requests.request_id%TYPE;
1045: x_status_meaning VARCHAR2(30);
1046: x_reason_meaning VARCHAR2(30);
1047: x_customer_trx_id ra_cm_requests.customer_trx_id%TYPE;
1048: x_cm_customer_trx_id ra_cm_requests.cm_customer_trx_id%TYPE;
1049: x_line_amount ra_cm_requests.line_amount%TYPE;
1050: x_tax_amount ra_cm_requests.tax_amount%TYPE;
1051: x_freight_amount ra_cm_requests.freight_amount%TYPE;

Line 1048: x_cm_customer_trx_id ra_cm_requests.cm_customer_trx_id%TYPE;

1044: l_request_id ra_cm_requests.request_id%TYPE;
1045: x_status_meaning VARCHAR2(30);
1046: x_reason_meaning VARCHAR2(30);
1047: x_customer_trx_id ra_cm_requests.customer_trx_id%TYPE;
1048: x_cm_customer_trx_id ra_cm_requests.cm_customer_trx_id%TYPE;
1049: x_line_amount ra_cm_requests.line_amount%TYPE;
1050: x_tax_amount ra_cm_requests.tax_amount%TYPE;
1051: x_freight_amount ra_cm_requests.freight_amount%TYPE;
1052: x_line_credits_flag ra_cm_requests.line_credits_flag%TYPE;

Line 1049: x_line_amount ra_cm_requests.line_amount%TYPE;

1045: x_status_meaning VARCHAR2(30);
1046: x_reason_meaning VARCHAR2(30);
1047: x_customer_trx_id ra_cm_requests.customer_trx_id%TYPE;
1048: x_cm_customer_trx_id ra_cm_requests.cm_customer_trx_id%TYPE;
1049: x_line_amount ra_cm_requests.line_amount%TYPE;
1050: x_tax_amount ra_cm_requests.tax_amount%TYPE;
1051: x_freight_amount ra_cm_requests.freight_amount%TYPE;
1052: x_line_credits_flag ra_cm_requests.line_credits_flag%TYPE;
1053: x_created_by NUMBER(15);

Line 1050: x_tax_amount ra_cm_requests.tax_amount%TYPE;

1046: x_reason_meaning VARCHAR2(30);
1047: x_customer_trx_id ra_cm_requests.customer_trx_id%TYPE;
1048: x_cm_customer_trx_id ra_cm_requests.cm_customer_trx_id%TYPE;
1049: x_line_amount ra_cm_requests.line_amount%TYPE;
1050: x_tax_amount ra_cm_requests.tax_amount%TYPE;
1051: x_freight_amount ra_cm_requests.freight_amount%TYPE;
1052: x_line_credits_flag ra_cm_requests.line_credits_flag%TYPE;
1053: x_created_by NUMBER(15);
1054: x_creation_date DATE;

Line 1051: x_freight_amount ra_cm_requests.freight_amount%TYPE;

1047: x_customer_trx_id ra_cm_requests.customer_trx_id%TYPE;
1048: x_cm_customer_trx_id ra_cm_requests.cm_customer_trx_id%TYPE;
1049: x_line_amount ra_cm_requests.line_amount%TYPE;
1050: x_tax_amount ra_cm_requests.tax_amount%TYPE;
1051: x_freight_amount ra_cm_requests.freight_amount%TYPE;
1052: x_line_credits_flag ra_cm_requests.line_credits_flag%TYPE;
1053: x_created_by NUMBER(15);
1054: x_creation_date DATE;
1055: x_approval_date DATE;

Line 1052: x_line_credits_flag ra_cm_requests.line_credits_flag%TYPE;

1048: x_cm_customer_trx_id ra_cm_requests.cm_customer_trx_id%TYPE;
1049: x_line_amount ra_cm_requests.line_amount%TYPE;
1050: x_tax_amount ra_cm_requests.tax_amount%TYPE;
1051: x_freight_amount ra_cm_requests.freight_amount%TYPE;
1052: x_line_credits_flag ra_cm_requests.line_credits_flag%TYPE;
1053: x_created_by NUMBER(15);
1054: x_creation_date DATE;
1055: x_approval_date DATE;
1056: x_comments ra_cm_requests.comments%TYPE;

Line 1056: x_comments ra_cm_requests.comments%TYPE;

1052: x_line_credits_flag ra_cm_requests.line_credits_flag%TYPE;
1053: x_created_by NUMBER(15);
1054: x_creation_date DATE;
1055: x_approval_date DATE;
1056: x_comments ra_cm_requests.comments%TYPE;
1057: x_cm_line_tbl AR_CREDIT_MEMO_API_PUB.Cm_Line_Tbl_Type_Cover%type;
1058: x_cm_activity_tbl AR_CREDIT_MEMO_API_PUB.x_cm_activity_tbl%type;
1059: x_cm_notes_tbl AR_CREDIT_MEMO_API_PUB.x_cm_notes_tbl%type;
1060: