APPS.POS_SPM_WF_PKG1 dependencies on POS_SUPPLIER_REGISTRATIONS

Line 1451: FROM pos_supplier_registrations

1447: x_ou_id OUT nocopy NUMBER)
1448: IS
1449: CURSOR l_cur IS
1450: SELECT ou_id
1451: FROM pos_supplier_registrations
1452: WHERE supplier_reg_id = p_supplier_reg_id;
1453: BEGIN
1454: OPEN l_cur;
1455: FETCH l_cur INTO x_ou_id;

Line 1469: FROM pos_supplier_registrations

1465: x_name OUT nocopy VARCHAR2)
1466: IS
1467: CURSOR l_cur IS
1468: SELECT supplier_name
1469: FROM pos_supplier_registrations
1470: WHERE supplier_reg_id = p_supplier_reg_id;
1471: BEGIN
1472: OPEN l_cur;
1473: FETCH l_cur INTO x_name;

Line 1909: FROM pos_supplier_registrations

1905: l_supplier_reg_id NUMBER;
1906:
1907: CURSOR l_cur IS
1908: SELECT note_to_supplier
1909: FROM pos_supplier_registrations
1910: WHERE supplier_reg_id = l_supplier_reg_id;
1911:
1912: l_rec l_cur%ROWTYPE;
1913: l_enterprise_name hz_parties.party_name%TYPE;

Line 1917: -- the document id should be the supplier_reg_id for the registration in pos_supplier_registrations

1913: l_enterprise_name hz_parties.party_name%TYPE;
1914: l_step NUMBER;
1915: BEGIN
1916: l_step := 0;
1917: -- the document id should be the supplier_reg_id for the registration in pos_supplier_registrations
1918: l_supplier_reg_id := To_number(document_id);
1919:
1920: l_step := 1;
1921: OPEN l_cur;

Line 2955: FROM pos_supplier_registrations psr,

2951: l_process wf_process_activities.process_name%TYPE;
2952:
2953: CURSOR l_cur IS
2954: SELECT psr.reg_key, pcr.first_name, pcr.last_name, pcr.email_address
2955: FROM pos_supplier_registrations psr,
2956: pos_contact_requests pcr,
2957: pos_supplier_mappings psm
2958: WHERE psr.supplier_reg_id = psm.supplier_reg_id
2959: AND psr.supplier_reg_id = p_supplier_reg_id

Line 3028: FROM pos_supplier_registrations psr,

3024: l_process wf_process_activities.process_name%TYPE;
3025:
3026: CURSOR l_cur IS
3027: SELECT psr.reg_key, pcr.first_name, pcr.last_name, pcr.email_address, psr.supplier_name
3028: FROM pos_supplier_registrations psr,
3029: pos_contact_requests pcr,
3030: pos_supplier_mappings psm
3031: WHERE psr.supplier_reg_id = psm.supplier_reg_id
3032: AND psr.supplier_reg_id = p_supplier_reg_id

Line 3138: FROM pos_supplier_registrations psr,

3134: L_FROM_NAME VARCHAR2(100);
3135:
3136: CURSOR l_cur IS
3137: SELECT psr.reg_key, pcr.first_name, pcr.last_name, pcr.email_address
3138: FROM pos_supplier_registrations psr,
3139: pos_contact_requests pcr,
3140: pos_supplier_mappings psm
3141: WHERE psr.supplier_reg_id = psm.supplier_reg_id
3142: AND psr.supplier_reg_id = p_supplier_reg_id