APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_CREDIT_REQUESTS

Line 20: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;

16: l_key VARCHAR2(240);
17: l_exist VARCHAR2(1);
18: l_event_name VARCHAR2(240) := 'oracle.apps.ar.cmgt.CreditRequestRecommendation.implement';
19: l_credit_request_id NUMBER;
20: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
21: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
22: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
23: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
24: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;

Line 21: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;

17: l_exist VARCHAR2(1);
18: l_event_name VARCHAR2(240) := 'oracle.apps.ar.cmgt.CreditRequestRecommendation.implement';
19: l_credit_request_id NUMBER;
20: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
21: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
22: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
23: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
24: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
25: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;

Line 22: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;

18: l_event_name VARCHAR2(240) := 'oracle.apps.ar.cmgt.CreditRequestRecommendation.implement';
19: l_credit_request_id NUMBER;
20: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
21: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
22: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
23: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
24: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
25: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
26: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;

Line 23: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;

19: l_credit_request_id NUMBER;
20: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
21: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
22: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
23: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
24: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
25: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
26: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
27: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;

Line 24: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;

20: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
21: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
22: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
23: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
24: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
25: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
26: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
27: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;
28: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;

Line 25: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;

21: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
22: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
23: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
24: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
25: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
26: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
27: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;
28: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;
29: l_case_folder_exists VARCHAR2(1);

Line 26: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;

22: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;
23: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
24: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
25: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
26: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
27: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;
28: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;
29: l_case_folder_exists VARCHAR2(1);
30:

Line 27: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;

23: l_source_column3 AR_CMGT_CREDIT_REQUESTS.source_column3%TYPE;
24: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
25: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
26: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
27: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;
28: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;
29: l_case_folder_exists VARCHAR2(1);
30:
31: CURSOR get_case_folder_info (p_cf_id IN NUMBER) IS

Line 28: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;

24: l_source_user_id ar_cmgt_credit_requests.SOURCE_USER_ID%type;
25: l_source_resp_id ar_cmgt_credit_requests.SOURCE_RESP_ID%type;
26: l_source_resp_appln_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
27: l_source_security_group_id ar_cmgt_credit_requests.SOURCE_SECURITY_GROUP_ID%type;
28: l_source_org_id ar_cmgt_credit_requests.SOURCE_ORG_ID%type;
29: l_case_folder_exists VARCHAR2(1);
30:
31: CURSOR get_case_folder_info (p_cf_id IN NUMBER) IS
32: SELECT cr.credit_request_id,

Line 40: FROM ar_cmgt_credit_requests cr,

36: cr.source_resp_id,
37: cr.source_resp_appln_id,
38: cr.source_security_group_id,
39: cr.source_org_id
40: FROM ar_cmgt_credit_requests cr,
41: ar_cmgt_case_folders cf
42: WHERE case_folder_id = p_cf_id
43: and cr.credit_request_id = cf.credit_request_id;
44:

Line 549: UPDATE ar_cmgt_credit_requests

545: update happens at both the levels (EO and at this API),
546: FND_RECORD_CHANGED_ERROR will be thrown
547: */
548: IF funcmode <> 'TRANSFER' THEN
549: UPDATE ar_cmgt_credit_requests
550: set credit_analyst_id = l_resource_id,
551: last_update_date = sysdate,
552: last_updated_by = fnd_global.user_id,
553: last_update_login = fnd_global.login_id

Line 676: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;

672: l_sic_code hz_parties.sic_code%type;
673: l_postal_code hz_parties.postal_code%type;
674: l_party_name hz_parties.party_name%type;
675: l_employees_total hz_parties.employees_total%type;
676: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
677: l_amount ar_cmgt_credit_requests.limit_amount%type;
678: l_review_type ar_cmgt_credit_requests.review_type%type;
679: l_profile_class_name hz_cust_profile_classes.name%type;
680: l_currency ar_cmgt_credit_requests.limit_currency%type;

Line 677: l_amount ar_cmgt_credit_requests.limit_amount%type;

673: l_postal_code hz_parties.postal_code%type;
674: l_party_name hz_parties.party_name%type;
675: l_employees_total hz_parties.employees_total%type;
676: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
677: l_amount ar_cmgt_credit_requests.limit_amount%type;
678: l_review_type ar_cmgt_credit_requests.review_type%type;
679: l_profile_class_name hz_cust_profile_classes.name%type;
680: l_currency ar_cmgt_credit_requests.limit_currency%type;
681: l_party_id hz_parties.party_id%type;

Line 678: l_review_type ar_cmgt_credit_requests.review_type%type;

674: l_party_name hz_parties.party_name%type;
675: l_employees_total hz_parties.employees_total%type;
676: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
677: l_amount ar_cmgt_credit_requests.limit_amount%type;
678: l_review_type ar_cmgt_credit_requests.review_type%type;
679: l_profile_class_name hz_cust_profile_classes.name%type;
680: l_currency ar_cmgt_credit_requests.limit_currency%type;
681: l_party_id hz_parties.party_id%type;
682:

Line 680: l_currency ar_cmgt_credit_requests.limit_currency%type;

676: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
677: l_amount ar_cmgt_credit_requests.limit_amount%type;
678: l_review_type ar_cmgt_credit_requests.review_type%type;
679: l_profile_class_name hz_cust_profile_classes.name%type;
680: l_currency ar_cmgt_credit_requests.limit_currency%type;
681: l_party_id hz_parties.party_id%type;
682:
683: /* 7132845 */
684: l_parent_request_id NUMBER;

Line 717: FROM ar_cmgt_credit_requests parent,

713: SELECT parent.credit_request_id,
714: parent.credit_analyst_id
715: INTO l_parent_request_id,
716: l_parent_analyst_id
717: FROM ar_cmgt_credit_requests parent,
718: ar_cmgt_credit_requests child
719: WHERE child.credit_request_id = p_credit_request_id
720: AND child.parent_credit_request_id = parent.credit_request_id
721: AND child.credit_request_type = 'GUARANTOR';

Line 718: ar_cmgt_credit_requests child

714: parent.credit_analyst_id
715: INTO l_parent_request_id,
716: l_parent_analyst_id
717: FROM ar_cmgt_credit_requests parent,
718: ar_cmgt_credit_requests child
719: WHERE child.credit_request_id = p_credit_request_id
720: AND child.parent_credit_request_id = parent.credit_request_id
721: AND child.credit_request_type = 'GUARANTOR';
722:

Line 774: FROM ar_cmgt_credit_requests c,

770: INTO l_country, l_state, l_province, l_sic_code,
771: l_party_name, l_employees_total, l_credit_classification,
772: l_amount, l_review_type, l_currency,
773: l_profile_class_name, l_postal_code, l_state, l_party_id
774: FROM ar_cmgt_credit_requests c,
775: hz_parties p,
776: hz_cust_profile_classes profclass,
777: hz_customer_profiles prof
778: WHERE c.credit_request_id = p_credit_request_id

Line 880: l_credit_analyst_id ar_cmgt_credit_requests.credit_analyst_id%type;

876:
877: l_user_name VARCHAR2(60);
878: l_display_name VARCHAR2(240);
879: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
880: l_credit_analyst_id ar_cmgt_credit_requests.credit_analyst_id%type;
881: l_employee_id per_people_f.person_id%type;
882: l_dummy VARCHAR2(1);
883: BEGIN
884: IF funcmode = 'RUN'

Line 905: FROM hz_customer_profiles a, ar_cmgt_credit_requests b

901: THEN
902: BEGIN
903: SELECT a.CREDIT_ANALYST_ID
904: INTO l_credit_analyst_id
905: FROM hz_customer_profiles a, ar_cmgt_credit_requests b
906: WHERE b.credit_request_id = itemkey
907: AND a.party_id = b.party_id
908: AND a.cust_account_id = decode(b.cust_account_id,-99,-1,b.cust_account_id)
909: AND nvl(a.site_use_id,-99) = nvl(b.site_use_id, -99);

Line 968: UPDATE ar_cmgt_credit_requests

964: END;
965:
966: get_employee_details(l_employee_id,l_user_name, l_display_name);
967:
968: UPDATE ar_cmgt_credit_requests
969: SET credit_analyst_id = l_credit_analyst_id,
970: last_update_date = sysdate,
971: last_updated_by = fnd_global.user_id,
972: last_update_login = fnd_global.login_id

Line 1136: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;

1132: actid in number,
1133: funcmode in varchar2,
1134: resultout out NOCOPY varchar2) IS
1135:
1136: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
1137: l_party_id ar_cmgt_credit_requests.party_id%type;
1138: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1139: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
1140:

Line 1137: l_party_id ar_cmgt_credit_requests.party_id%type;

1133: funcmode in varchar2,
1134: resultout out NOCOPY varchar2) IS
1135:
1136: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
1137: l_party_id ar_cmgt_credit_requests.party_id%type;
1138: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1139: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
1140:
1141: l_sql_statement VARCHAR2(2000);

Line 1138: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;

1134: resultout out NOCOPY varchar2) IS
1135:
1136: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
1137: l_party_id ar_cmgt_credit_requests.party_id%type;
1138: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1139: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
1140:
1141: l_sql_statement VARCHAR2(2000);
1142:

Line 1139: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;

1135:
1136: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
1137: l_party_id ar_cmgt_credit_requests.party_id%type;
1138: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1139: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
1140:
1141: l_sql_statement VARCHAR2(2000);
1142:
1143: BEGIN

Line 1148: FROM ar_cmgt_credit_requests

1144: IF funcmode = 'RUN'
1145: THEN
1146: SELECT credit_classification, party_id, cust_account_id, site_use_id
1147: INTO l_credit_classification, l_party_id, l_cust_account_id, l_site_use_id
1148: FROM ar_cmgt_credit_requests
1149: WHERE credit_request_id = itemkey;
1150:
1151: IF l_credit_classification IS NULL
1152: THEN

Line 1157: UPDATE ar_cmgt_credit_requests

1153:
1154: l_credit_classification := AR_CMGT_UTIL.get_credit_classification(p_party_id => l_party_id,
1155: p_cust_account_id => l_cust_account_id,
1156: p_site_use_id => l_site_use_id);
1157: UPDATE ar_cmgt_credit_requests
1158: SET credit_classification = l_credit_classification
1159: WHERE credit_request_id = itemkey;
1160: END IF; -- end of credit classification
1161: -- Now update the credit classification in wf

Line 1186: UPDATE ar_cmgt_credit_requests

1182: BEGIN
1183:
1184: IF funcmode = 'RUN'
1185: THEN
1186: UPDATE ar_cmgt_credit_requests
1187: SET status = 'IN_PROCESS',
1188: last_update_date = sysdate,
1189: last_updated_by = fnd_global.user_id,
1190: last_update_login = fnd_global.login_id

Line 1208: UPDATE ar_cmgt_credit_requests

1204: BEGIN
1205:
1206: IF funcmode = 'RUN'
1207: THEN
1208: UPDATE ar_cmgt_credit_requests
1209: SET status = 'SUBMIT',
1210: last_update_date = sysdate,
1211: last_updated_by = fnd_global.user_id,
1212: last_update_login = fnd_global.login_id

Line 1289: l_party_id ar_cmgt_credit_requests.party_id%type;

1285: actid in number,
1286: funcmode in varchar2,
1287: resultout out NOCOPY varchar2) IS
1288:
1289: l_party_id ar_cmgt_credit_requests.party_id%type;
1290: l_cust_acct_id ar_cmgt_credit_requests.cust_account_id%type;
1291: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
1292: l_cust_account_profile_id hz_customer_profiles.cust_account_profile_id%type;
1293: l_return_status VARCHAR2(1);

Line 1290: l_cust_acct_id ar_cmgt_credit_requests.cust_account_id%type;

1286: funcmode in varchar2,
1287: resultout out NOCOPY varchar2) IS
1288:
1289: l_party_id ar_cmgt_credit_requests.party_id%type;
1290: l_cust_acct_id ar_cmgt_credit_requests.cust_account_id%type;
1291: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
1292: l_cust_account_profile_id hz_customer_profiles.cust_account_profile_id%type;
1293: l_return_status VARCHAR2(1);
1294: BEGIN

Line 1291: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;

1287: resultout out NOCOPY varchar2) IS
1288:
1289: l_party_id ar_cmgt_credit_requests.party_id%type;
1290: l_cust_acct_id ar_cmgt_credit_requests.cust_account_id%type;
1291: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
1292: l_cust_account_profile_id hz_customer_profiles.cust_account_profile_id%type;
1293: l_return_status VARCHAR2(1);
1294: BEGIN
1295: IF pg_wf_debug = 'Y'

Line 1305: FROM ar_cmgt_credit_requests

1301: IF funcmode = 'RUN'
1302: THEN
1303: SELECT party_id, cust_account_id, site_use_id
1304: INTO l_party_id, l_cust_acct_id, l_site_use_id
1305: FROM ar_cmgt_credit_requests
1306: WHERE credit_request_id = itemkey;
1307:
1308: /* 9283064 - Determine if request is party, acct, or site
1309: level. Only proceed if it is party-level */

Line 1400: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;

1396: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1397: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1398: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1399: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1400: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1401: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
1402: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1403: l_source_name ar_cmgt_credit_requests.source_name%type;
1404: l_classification_meaning ar_lookups.meaning%type;

Line 1401: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;

1397: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1398: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1399: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1400: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1401: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
1402: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1403: l_source_name ar_cmgt_credit_requests.source_name%type;
1404: l_classification_meaning ar_lookups.meaning%type;
1405: l_review_type_meaning ar_lookups.meaning%type;

Line 1403: l_source_name ar_cmgt_credit_requests.source_name%type;

1399: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1400: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1401: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
1402: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1403: l_source_name ar_cmgt_credit_requests.source_name%type;
1404: l_classification_meaning ar_lookups.meaning%type;
1405: l_review_type_meaning ar_lookups.meaning%type;
1406: l_application_number ar_cmgt_credit_requests.application_number%type;
1407: l_score_model_already_set VARCHAR2(1) := 'F';

Line 1406: l_application_number ar_cmgt_credit_requests.application_number%type;

1402: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1403: l_source_name ar_cmgt_credit_requests.source_name%type;
1404: l_classification_meaning ar_lookups.meaning%type;
1405: l_review_type_meaning ar_lookups.meaning%type;
1406: l_application_number ar_cmgt_credit_requests.application_number%type;
1407: l_score_model_already_set VARCHAR2(1) := 'F';
1408: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
1409: l_requestor_user_name fnd_user.user_name%type;
1410: l_requestor_display_name per_people_f.full_name%type;

Line 1408: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;

1404: l_classification_meaning ar_lookups.meaning%type;
1405: l_review_type_meaning ar_lookups.meaning%type;
1406: l_application_number ar_cmgt_credit_requests.application_number%type;
1407: l_score_model_already_set VARCHAR2(1) := 'F';
1408: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
1409: l_requestor_user_name fnd_user.user_name%type;
1410: l_requestor_display_name per_people_f.full_name%type;
1411: l_party_id hz_parties.party_id%type;
1412: l_cust_account_id hz_cust_accounts.cust_account_id%type;

Line 1416: l_application_date ar_cmgt_credit_requests.application_date%type;

1412: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1413: l_party_name hz_parties.party_name%type;
1414: l_party_number hz_parties.party_number%type;
1415: l_account_number hz_cust_accounts.account_number%type;
1416: l_application_date ar_cmgt_credit_requests.application_date%type;
1417: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
1418: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
1419: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
1420: l_notes ar_cmgt_credit_requests.notes%type;

Line 1417: l_source_column1 ar_cmgt_credit_requests.source_column1%type;

1413: l_party_name hz_parties.party_name%type;
1414: l_party_number hz_parties.party_number%type;
1415: l_account_number hz_cust_accounts.account_number%type;
1416: l_application_date ar_cmgt_credit_requests.application_date%type;
1417: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
1418: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
1419: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
1420: l_notes ar_cmgt_credit_requests.notes%type;
1421: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;

Line 1418: l_source_column2 ar_cmgt_credit_requests.source_column2%type;

1414: l_party_number hz_parties.party_number%type;
1415: l_account_number hz_cust_accounts.account_number%type;
1416: l_application_date ar_cmgt_credit_requests.application_date%type;
1417: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
1418: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
1419: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
1420: l_notes ar_cmgt_credit_requests.notes%type;
1421: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
1422: l_requestor_type ar_cmgt_credit_requests.requestor_type%type;

Line 1419: l_source_column3 ar_cmgt_credit_requests.source_column3%type;

1415: l_account_number hz_cust_accounts.account_number%type;
1416: l_application_date ar_cmgt_credit_requests.application_date%type;
1417: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
1418: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
1419: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
1420: l_notes ar_cmgt_credit_requests.notes%type;
1421: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
1422: l_requestor_type ar_cmgt_credit_requests.requestor_type%type;
1423:

Line 1420: l_notes ar_cmgt_credit_requests.notes%type;

1416: l_application_date ar_cmgt_credit_requests.application_date%type;
1417: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
1418: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
1419: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
1420: l_notes ar_cmgt_credit_requests.notes%type;
1421: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
1422: l_requestor_type ar_cmgt_credit_requests.requestor_type%type;
1423:
1424: BEGIN

Line 1421: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;

1417: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
1418: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
1419: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
1420: l_notes ar_cmgt_credit_requests.notes%type;
1421: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
1422: l_requestor_type ar_cmgt_credit_requests.requestor_type%type;
1423:
1424: BEGIN
1425: IF funcmode = 'RUN'

Line 1422: l_requestor_type ar_cmgt_credit_requests.requestor_type%type;

1418: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
1419: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
1420: l_notes ar_cmgt_credit_requests.notes%type;
1421: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
1422: l_requestor_type ar_cmgt_credit_requests.requestor_type%type;
1423:
1424: BEGIN
1425: IF funcmode = 'RUN'
1426: THEN

Line 1471: FROM ar_cmgt_credit_requests req,

1467: l_party_number,
1468: l_notes,
1469: l_credit_request_type,
1470: l_requestor_type
1471: FROM ar_cmgt_credit_requests req,
1472: ar_lookups lkp1,
1473: ar_lookups lkp2,
1474: hz_parties party
1475: WHERE req.credit_request_id = itemkey

Line 1519: FROM ar_cmgt_credit_requests req,

1515: l_currency,
1516: l_amount_requested,
1517: l_credit_request_type,
1518: l_requestor_type
1519: FROM ar_cmgt_credit_requests req,
1520: hz_parties party
1521: WHERE credit_request_id = itemkey
1522: AND req.party_id = party.party_id;
1523:

Line 1732: UPDATE ar_cmgt_credit_requests

1728: itemkey => itemkey,
1729: aname => 'CHECK_LIST_ID',
1730: avalue => l_check_list_id);
1731: --Update credit request table with checklistid
1732: UPDATE ar_cmgt_credit_requests
1733: set check_list_id = l_check_list_id
1734: WHERE credit_request_id = itemkey;
1735:
1736: resultout := 'COMPLETE:FOUND';

Line 1834: l_trx_amount ar_cmgt_credit_requests.TRX_AMOUNT%TYPE;

1830:
1831:
1832: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1833: l_score_model_id_1 ar_cmgt_scores.score_model_id%TYPE;
1834: l_trx_amount ar_cmgt_credit_requests.TRX_AMOUNT%TYPE;
1835:
1836:
1837: BEGIN
1838: IF funcmode = 'RUN'

Line 1861: FROM ar_cmgt_credit_requests

1857: */
1858:
1859: SELECT trx_amount
1860: INTO l_trx_amount
1861: FROM ar_cmgt_credit_requests
1862: WHERE credit_request_id = itemkey;
1863:
1864: WF_ENGINE.setItemAttrNumber
1865: (itemtype => itemtype,

Line 1903: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;

1899: actid in number,
1900: funcmode in varchar2,
1901: resultout out NOCOPY varchar2) IS
1902:
1903: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;
1904: l_score_currency ar_cmgt_scores.currency%type;
1905: l_score_model_id ar_cmgt_scores.score_model_id%type;
1906: BEGIN
1907:

Line 1997: l_party_id ar_cmgt_credit_requests.party_id%type;

1993:
1994: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1995: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1996: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1997: l_party_id ar_cmgt_credit_requests.party_id%type;
1998: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1999: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;
2000: l_request_id ar_cmgt_credit_requests.credit_request_id%type;
2001: l_trx_currency ar_cmgt_credit_requests.trx_currency%type;

Line 1998: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;

1994: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1995: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1996: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1997: l_party_id ar_cmgt_credit_requests.party_id%type;
1998: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1999: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;
2000: l_request_id ar_cmgt_credit_requests.credit_request_id%type;
2001: l_trx_currency ar_cmgt_credit_requests.trx_currency%type;
2002: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;

Line 1999: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;

1995: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1996: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1997: l_party_id ar_cmgt_credit_requests.party_id%type;
1998: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1999: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;
2000: l_request_id ar_cmgt_credit_requests.credit_request_id%type;
2001: l_trx_currency ar_cmgt_credit_requests.trx_currency%type;
2002: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;
2003: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;

Line 2000: l_request_id ar_cmgt_credit_requests.credit_request_id%type;

1996: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1997: l_party_id ar_cmgt_credit_requests.party_id%type;
1998: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1999: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;
2000: l_request_id ar_cmgt_credit_requests.credit_request_id%type;
2001: l_trx_currency ar_cmgt_credit_requests.trx_currency%type;
2002: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;
2003: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
2004: l_org_id NUMBER ;

Line 2001: l_trx_currency ar_cmgt_credit_requests.trx_currency%type;

1997: l_party_id ar_cmgt_credit_requests.party_id%type;
1998: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1999: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;
2000: l_request_id ar_cmgt_credit_requests.credit_request_id%type;
2001: l_trx_currency ar_cmgt_credit_requests.trx_currency%type;
2002: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;
2003: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
2004: l_org_id NUMBER ;
2005: l_score_model_id NUMBER;

Line 2002: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;

1998: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1999: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;
2000: l_request_id ar_cmgt_credit_requests.credit_request_id%type;
2001: l_trx_currency ar_cmgt_credit_requests.trx_currency%type;
2002: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;
2003: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
2004: l_org_id NUMBER ;
2005: l_score_model_id NUMBER;
2006: l_credit_request_id NUMBER;

Line 2025: FROM ar_cmgt_credit_requests

2021: source_org_id, case_folder_number
2022: INTO l_credit_classification, l_review_type, l_cust_account_id,
2023: l_party_id, l_cust_acct_site_id, l_trx_currency, l_org_id,
2024: l_case_folder_number
2025: FROM ar_cmgt_credit_requests
2026: WHERE credit_request_id = itemkey;
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,

Line 2030: 'Error while getting records from AR_CMGT_CREDIT_REQUESTS',

2026: WHERE credit_request_id = itemkey;
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029: wf_core.context ('AR_CMGT_WF_ENGINE','GATHER_DATA_POINTS',itemtype,itemkey,
2030: 'Error while getting records from AR_CMGT_CREDIT_REQUESTS',
2031: 'Sql Error: '||sqlerrm);
2032: raise;
2033: END;
2034: l_check_list_id := WF_ENGINE.getItemAttrNumber

Line 2271: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;

2267: l_score NUMBER;
2268: l_auto_rules_id NUMBER;
2269: l_override_checklist ar_cmgt_auto_rule_dtls.override_checklist_flag%type;
2270: l_skip_approval ar_cmgt_auto_rule_dtls.skip_approval_flag%type;
2271: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
2272: l_trans_currency ar_cmgt_credit_requests.trx_currency%TYPE; -- Fixed for bug 9871620
2273: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE; -- Fixed for bug 9871620
2274: BEGIN
2275: IF funcmode = 'RUN'

Line 2272: l_trans_currency ar_cmgt_credit_requests.trx_currency%TYPE; -- Fixed for bug 9871620

2268: l_auto_rules_id NUMBER;
2269: l_override_checklist ar_cmgt_auto_rule_dtls.override_checklist_flag%type;
2270: l_skip_approval ar_cmgt_auto_rule_dtls.skip_approval_flag%type;
2271: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
2272: l_trans_currency ar_cmgt_credit_requests.trx_currency%TYPE; -- Fixed for bug 9871620
2273: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE; -- Fixed for bug 9871620
2274: BEGIN
2275: IF funcmode = 'RUN'
2276: THEN

Line 2866: l_currency_code ar_cmgt_credit_requests.limit_currency%type;

2862: l_errmsg VARCHAR2(2000);
2863: l_resultout VARCHAR2(1);
2864:
2865:
2866: l_currency_code ar_cmgt_credit_requests.limit_currency%type;
2867: l_credit_type ar_cmgt_credit_requests.credit_type%type;
2868: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
2869: l_exposure NUMBER;
2870: l_risk_factor NUMBER;

Line 2867: l_credit_type ar_cmgt_credit_requests.credit_type%type;

2863: l_resultout VARCHAR2(1);
2864:
2865:
2866: l_currency_code ar_cmgt_credit_requests.limit_currency%type;
2867: l_credit_type ar_cmgt_credit_requests.credit_type%type;
2868: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
2869: l_exposure NUMBER;
2870: l_risk_factor NUMBER;
2871:

Line 2868: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;

2864:
2865:
2866: l_currency_code ar_cmgt_credit_requests.limit_currency%type;
2867: l_credit_type ar_cmgt_credit_requests.credit_type%type;
2868: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
2869: l_exposure NUMBER;
2870: l_risk_factor NUMBER;
2871:
2872:

Line 2887: FROM ar_cmgt_credit_requests

2883: THEN
2884: -- get credit type from credit requests
2885: SELECT CREDIT_TYPE, credit_request_type
2886: INTO l_credit_type, l_credit_request_type
2887: FROM ar_cmgt_credit_requests
2888: WHERE credit_request_id = itemkey;
2889:
2890: -- in case of Guarantor no reco. will be generated
2891: IF l_credit_request_type = 'GUARANTOR'

Line 3159: Update ar_cmgt_credit_requests

3155: last_updated_by = fnd_global.user_id,
3156: last_update_login = fnd_global.login_id
3157: WHERE case_folder_id = l_case_folder_id;
3158:
3159: Update ar_cmgt_credit_requests
3160: set status = 'PROCESSED',
3161: last_update_date = sysdate,
3162: last_updated_by = fnd_global.user_id,
3163: last_update_login = fnd_global.login_id

Line 3177: l_credit_type ar_cmgt_credit_requests.credit_type%type;

3173: funcmode in varchar2,
3174: resultout out NOCOPY varchar2) IS
3175:
3176: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3177: l_credit_type ar_cmgt_credit_requests.credit_type%type;
3178: l_party_id ar_cmgt_credit_requests.party_id%type;
3179: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
3180: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3181: l_error_msg VARCHAR2(2000);

Line 3178: l_party_id ar_cmgt_credit_requests.party_id%type;

3174: resultout out NOCOPY varchar2) IS
3175:
3176: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3177: l_credit_type ar_cmgt_credit_requests.credit_type%type;
3178: l_party_id ar_cmgt_credit_requests.party_id%type;
3179: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
3180: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3181: l_error_msg VARCHAR2(2000);
3182: l_return_status VARCHAR2(1);

Line 3179: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;

3175:
3176: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3177: l_credit_type ar_cmgt_credit_requests.credit_type%type;
3178: l_party_id ar_cmgt_credit_requests.party_id%type;
3179: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
3180: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3181: l_error_msg VARCHAR2(2000);
3182: l_return_status VARCHAR2(1);
3183: HOLD_ERROR EXCEPTION;

Line 3180: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;

3176: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3177: l_credit_type ar_cmgt_credit_requests.credit_type%type;
3178: l_party_id ar_cmgt_credit_requests.party_id%type;
3179: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
3180: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3181: l_error_msg VARCHAR2(2000);
3182: l_return_status VARCHAR2(1);
3183: HOLD_ERROR EXCEPTION;
3184: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;

Line 3213: FROM ar_cmgt_credit_requests

3209: BEGIN
3210: SELECT party_id, decode(cust_account_id,-99,-1,cust_account_id),
3211: decode(site_use_id,-99,null,site_use_id), credit_type
3212: INTO l_party_id, l_cust_account_id, l_site_use_id, l_credit_type
3213: FROM ar_cmgt_credit_requests
3214: WHERE credit_request_id = itemkey;
3215:
3216: END;
3217:

Line 3446: Update ar_cmgt_credit_requests

3442: last_updated_by = fnd_global.user_id,
3443: last_update_login = fnd_global.login_id
3444: WHERE case_folder_id = l_case_folder_id;
3445:
3446: Update ar_cmgt_credit_requests
3447: set status = 'PROCESSED',
3448: last_update_date = sysdate,
3449: last_updated_by = fnd_global.user_id,
3450: last_update_login = fnd_global.login_id

Line 3472: l_party_id ar_cmgt_credit_requests.party_id%type;

3468: funcmode in varchar2,
3469: resultout out NOCOPY varchar2) IS
3470:
3471: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3472: l_party_id ar_cmgt_credit_requests.party_id%type;
3473: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
3474: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3475: l_credit_limit NUMBER := 0;
3476: l_exposure NUMBER;

Line 3473: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;

3469: resultout out NOCOPY varchar2) IS
3470:
3471: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3472: l_party_id ar_cmgt_credit_requests.party_id%type;
3473: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
3474: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3475: l_credit_limit NUMBER := 0;
3476: l_exposure NUMBER;
3477: l_risk_factor NUMBER;

Line 3474: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;

3470:
3471: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3472: l_party_id ar_cmgt_credit_requests.party_id%type;
3473: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
3474: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3475: l_credit_limit NUMBER := 0;
3476: l_exposure NUMBER;
3477: l_risk_factor NUMBER;
3478: l_limit_currency ar_cmgt_case_folders.limit_currency%type;

Line 3535: FROM ar_cmgt_credit_requests

3531: BEGIN
3532: SELECT party_id, decode(cust_account_id,-99,-1,cust_account_id),
3533: decode(site_use_id,-99,null,site_use_id)
3534: INTO l_party_id, l_cust_account_id, l_site_use_id
3535: FROM ar_cmgt_credit_requests
3536: WHERE credit_request_id = itemkey;
3537:
3538: END;
3539: l_case_folder_id := WF_ENGINE.GetItemAttrNumber

Line 3593: FROM ar_cmgt_credit_requests a, ar_cmgt_credit_requests b

3589: -- Now Release the parent credit request from HOLD(if any)
3590: BEGIN
3591: SELECT a.parent_credit_request_id
3592: INTO l_parent_credit_request_id
3593: FROM ar_cmgt_credit_requests a, ar_cmgt_credit_requests b
3594: WHERE a.credit_request_id = itemkey
3595: AND a.parent_credit_request_id = b.credit_request_id
3596: AND b.status <> 'PROCESSED';
3597:

Line 3832: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;

3828: actid in number,
3829: funcmode in varchar2,
3830: resultout out NOCOPY varchar2) IS
3831:
3832: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;
3833: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
3834: l_status ar_cmgt_case_folders.status%type;
3835:
3836: BEGIN

Line 3833: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;

3829: funcmode in varchar2,
3830: resultout out NOCOPY varchar2) IS
3831:
3832: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;
3833: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
3834: l_status ar_cmgt_case_folders.status%type;
3835:
3836: BEGIN
3837: IF funcmode = 'RUN'

Line 3842: FROM ar_cmgt_credit_requests r

3838: THEN
3839: BEGIN
3840: SELECT r.credit_request_id, r.credit_request_type, r.status
3841: INTO l_credit_request_id, l_credit_request_type, l_status
3842: FROM ar_cmgt_credit_requests r
3843: WHERE r.parent_credit_request_id = itemkey
3844: AND r.status <> 'PROCESSED';
3845:
3846: resultout := 'COMPLETE:N';

Line 3873: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;

3869: resultout out NOCOPY varchar2) IS
3870:
3871: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
3872: l_reco_exist VARCHAR2(1) := 'N';
3873: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
3874: l_flag varchar2(1);
3875: UNEXP_ERROR EXCEPTION;
3876: --this will check if recommendations exists or not.
3877: CURSOR CHECK_RECO_EXISTS IS

Line 3942: FROM ar_cmgt_cf_recommends cf, ar_cmgt_credit_requests req

3938: -- do the next validations
3939: BEGIN
3940: SELECT 'X'
3941: INTO l_flag
3942: FROM ar_cmgt_cf_recommends cf, ar_cmgt_credit_requests req
3943: WHERE req.credit_request_id = itemkey
3944: AND req.credit_request_id = cf.credit_request_id
3945: AND req.cust_account_id = -99
3946: AND req.site_use_id = -99

Line 4032: l_credit_type ar_cmgt_credit_requests.credit_type%type;

4028: l_errmsg VARCHAR2(2000);
4029: l_resultout VARCHAR2(1);
4030: l_processng_flag VARCHAR2(1);
4031: l_case_rec_num NUMBER;
4032: l_credit_type ar_cmgt_credit_requests.credit_type%type;
4033: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
4034: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
4035: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;
4036: l_parent_creq_id ar_cmgt_credit_requests.parent_credit_request_id%type;

Line 4033: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;

4029: l_resultout VARCHAR2(1);
4030: l_processng_flag VARCHAR2(1);
4031: l_case_rec_num NUMBER;
4032: l_credit_type ar_cmgt_credit_requests.credit_type%type;
4033: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
4034: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
4035: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;
4036: l_parent_creq_id ar_cmgt_credit_requests.parent_credit_request_id%type;
4037: insert_failure EXCEPTION;

Line 4036: l_parent_creq_id ar_cmgt_credit_requests.parent_credit_request_id%type;

4032: l_credit_type ar_cmgt_credit_requests.credit_type%type;
4033: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
4034: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
4035: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;
4036: l_parent_creq_id ar_cmgt_credit_requests.parent_credit_request_id%type;
4037: insert_failure EXCEPTION;
4038: l_cf_id ar_cmgt_case_folders.case_folder_id%type;
4039: populate_failure EXCEPTION;
4040:

Line 4060: FROM ar_cmgt_credit_requests

4056: BEGIN
4057:
4058: SELECT credit_request_type
4059: INTO l_credit_request_type
4060: FROM ar_cmgt_credit_requests
4061: WHERE credit_request_id = itemkey;
4062: EXCEPTION
4063: WHEN OTHERS THEN
4064: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,

Line 4065: 'Error while getting records from AR_CMGT_CREDIT_REQUESTS',

4061: WHERE credit_request_id = itemkey;
4062: EXCEPTION
4063: WHEN OTHERS THEN
4064: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,
4065: 'Error while getting records from AR_CMGT_CREDIT_REQUESTS',
4066: 'Sql Error: '||sqlerrm);
4067: raise;
4068: END;
4069:

Line 4093: FROM AR_CMGT_CREDIT_REQUESTS

4089: BEGIN
4090:
4091: SELECT PARENT_CREDIT_REQUEST_ID
4092: INTO l_parent_creq_id
4093: FROM AR_CMGT_CREDIT_REQUESTS
4094: WHERE CREDIT_REQUEST_ID = itemkey;
4095:
4096: EXCEPTION
4097: WHEN OTHERS THEN

Line 4099: 'Error while getting parent records from AR_CMGT_CREDIT_REQUESTS',

4095:
4096: EXCEPTION
4097: WHEN OTHERS THEN
4098: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,
4099: 'Error while getting parent records from AR_CMGT_CREDIT_REQUESTS',
4100: 'Sql Error: '||sqlerrm);
4101: raise;
4102: END;
4103:

Line 4319: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;

4315: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
4316: l_review_type ar_cmgt_check_lists.review_type%TYPE;
4317: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
4318: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
4319: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
4320: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
4321: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
4322: l_source_name ar_cmgt_credit_requests.source_name%type;
4323: l_classification_meaning ar_lookups.meaning%type;

Line 4320: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;

4316: l_review_type ar_cmgt_check_lists.review_type%TYPE;
4317: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
4318: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
4319: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
4320: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
4321: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
4322: l_source_name ar_cmgt_credit_requests.source_name%type;
4323: l_classification_meaning ar_lookups.meaning%type;
4324: l_review_type_meaning ar_lookups.meaning%type;

Line 4322: l_source_name ar_cmgt_credit_requests.source_name%type;

4318: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
4319: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
4320: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
4321: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
4322: l_source_name ar_cmgt_credit_requests.source_name%type;
4323: l_classification_meaning ar_lookups.meaning%type;
4324: l_review_type_meaning ar_lookups.meaning%type;
4325: l_application_number ar_cmgt_credit_requests.application_number%type;
4326: l_score_model_already_set VARCHAR2(1) := 'F';

Line 4325: l_application_number ar_cmgt_credit_requests.application_number%type;

4321: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
4322: l_source_name ar_cmgt_credit_requests.source_name%type;
4323: l_classification_meaning ar_lookups.meaning%type;
4324: l_review_type_meaning ar_lookups.meaning%type;
4325: l_application_number ar_cmgt_credit_requests.application_number%type;
4326: l_score_model_already_set VARCHAR2(1) := 'F';
4327: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
4328: l_requestor_user_name fnd_user.user_name%type;
4329: l_requestor_display_name per_people_f.full_name%type;

Line 4327: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;

4323: l_classification_meaning ar_lookups.meaning%type;
4324: l_review_type_meaning ar_lookups.meaning%type;
4325: l_application_number ar_cmgt_credit_requests.application_number%type;
4326: l_score_model_already_set VARCHAR2(1) := 'F';
4327: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
4328: l_requestor_user_name fnd_user.user_name%type;
4329: l_requestor_display_name per_people_f.full_name%type;
4330: l_party_id hz_parties.party_id%type;
4331: l_cust_account_id hz_cust_accounts.cust_account_id%type;

Line 4335: l_application_date ar_cmgt_credit_requests.application_date%type;

4331: l_cust_account_id hz_cust_accounts.cust_account_id%type;
4332: l_party_name hz_parties.party_name%type;
4333: l_party_number hz_parties.party_number%type;
4334: l_account_number hz_cust_accounts.account_number%type;
4335: l_application_date ar_cmgt_credit_requests.application_date%type;
4336: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
4337: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
4338: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
4339: l_notes ar_cmgt_credit_requests.notes%type;

Line 4336: l_source_column1 ar_cmgt_credit_requests.source_column1%type;

4332: l_party_name hz_parties.party_name%type;
4333: l_party_number hz_parties.party_number%type;
4334: l_account_number hz_cust_accounts.account_number%type;
4335: l_application_date ar_cmgt_credit_requests.application_date%type;
4336: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
4337: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
4338: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
4339: l_notes ar_cmgt_credit_requests.notes%type;
4340: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;

Line 4337: l_source_column2 ar_cmgt_credit_requests.source_column2%type;

4333: l_party_number hz_parties.party_number%type;
4334: l_account_number hz_cust_accounts.account_number%type;
4335: l_application_date ar_cmgt_credit_requests.application_date%type;
4336: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
4337: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
4338: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
4339: l_notes ar_cmgt_credit_requests.notes%type;
4340: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
4341: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;

Line 4338: l_source_column3 ar_cmgt_credit_requests.source_column3%type;

4334: l_account_number hz_cust_accounts.account_number%type;
4335: l_application_date ar_cmgt_credit_requests.application_date%type;
4336: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
4337: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
4338: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
4339: l_notes ar_cmgt_credit_requests.notes%type;
4340: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
4341: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;
4342: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;

Line 4339: l_notes ar_cmgt_credit_requests.notes%type;

4335: l_application_date ar_cmgt_credit_requests.application_date%type;
4336: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
4337: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
4338: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
4339: l_notes ar_cmgt_credit_requests.notes%type;
4340: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
4341: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;
4342: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;
4343: l_requestor_type ar_cmgt_credit_requests.requestor_type%TYPE;

Line 4343: l_requestor_type ar_cmgt_credit_requests.requestor_type%TYPE;

4339: l_notes ar_cmgt_credit_requests.notes%type;
4340: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
4341: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;
4342: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;
4343: l_requestor_type ar_cmgt_credit_requests.requestor_type%TYPE;
4344:
4345: BEGIN
4346: IF funcmode = 'RUN'
4347: THEN

Line 4384: FROM ar_cmgt_credit_requests req,

4380: l_party_name,
4381: l_party_number,
4382: l_notes,
4383: l_requestor_type
4384: FROM ar_cmgt_credit_requests req,
4385: ar_lookups lkp1,
4386: ar_lookups lkp2,
4387: hz_parties party
4388: WHERE req.credit_request_id = itemkey

Line 4430: FROM ar_cmgt_credit_requests req,

4426: l_case_folder_number,
4427: l_currency,
4428: l_amount_requested,
4429: l_requestor_type
4430: FROM ar_cmgt_credit_requests req,
4431: hz_parties party
4432: WHERE credit_request_id = itemkey
4433: AND req.party_id = party.party_id;
4434: WHEN OTHERS THEN

Line 4743: l_credit_type ar_cmgt_credit_requests.credit_type%type;

4739: resultout out NOCOPY varchar2) IS
4740:
4741: l_score NUMBER;
4742: l_score_model_id ar_cmgt_case_folders.score_model_id%type;
4743: l_credit_type ar_cmgt_credit_requests.credit_type%type;
4744: l_resultout VARCHAR2(1);
4745: l_errmsg VARCHAR2(32767);
4746: l_credit_limit NUMBER := 0;
4747: insert_failure EXCEPTION;

Line 4761: from ar_cmgt_case_folders cf,ar_cmgt_credit_requests cr

4757:
4758: --get detailz
4759: CURSOR get_details IS
4760: SELECT cf.score_model_id,cr.credit_type
4761: from ar_cmgt_case_folders cf,ar_cmgt_credit_requests cr
4762: where case_folder_id=p_cf_id
4763: and cr.credit_request_id=cf.credit_request_id;
4764:
4765: