APPS.PAY_IP_UTILITY dependencies on FND_APPLICATION

Line 73: from FND_APPLICATION

69: RETURN NUMBER is
70:
71: CURSOR CSR_APPLICATION (X_APPLICATION_SHORT_NAME in VARCHAR2) is
72: select APPLICATION_ID
73: from FND_APPLICATION
74: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME;
75: X_APPLICATION CSR_APPLICATION%rowtype;
76: begin
77: open CSR_APPLICATION(X_APPLICATION_SHORT_NAME);

Line 443: ,X_FND_APPLICATION_ID => lv_APPLICATION_ID

439: ( X_ORG_INFORMATION_TYPE => p_ORG_INFORMATION_TYPE
440: ,X_DESTINATION => p_DESTINATION
441: ,X_LEGISLATION_CODE => p_LEGISLATION_CODE
442: ,X_NAVIGATION_METHOD => p_NAVIGATION_METHOD
443: ,X_FND_APPLICATION_ID => lv_APPLICATION_ID
444: ,X_DESCRIPTION => p_DESCRIPTION
445: ,X_DISPLAYED_ORG_INFORMATION_TP => p_DISP_ORG_INFORMATION_TYPE
446: ,X_LAST_UPDATE_DATE => lv_LAST_UPDATE_DATE
447: ,X_LAST_UPDATED_BY => lv_LAST_UPDATED_BY

Line 455: ,X_FND_APPLICATION_ID => lv_APPLICATION_ID

451: ( X_ORG_INFORMATION_TYPE => p_ORG_INFORMATION_TYPE
452: ,X_DESTINATION => p_DESTINATION
453: ,X_LEGISLATION_CODE => p_LEGISLATION_CODE
454: ,X_NAVIGATION_METHOD => p_NAVIGATION_METHOD
455: ,X_FND_APPLICATION_ID => lv_APPLICATION_ID
456: ,X_DESCRIPTION => p_DESCRIPTION
457: ,X_DISPLAYED_ORG_INFORMATION_TP => p_DISP_ORG_INFORMATION_TYPE
458: ,X_CREATION_DATE => lv_CREATION_DATE
459: ,X_CREATED_BY => lv_CREATED_BY

Line 813: l_application_id fnd_application.application_id%TYPE;

809: FUNCTION get_application_id(p_application_short_name IN VARCHAR2)
810: RETURN VARCHAR2
811: IS
812: l_func_name VARCHAR2(80);
813: l_application_id fnd_application.application_id%TYPE;
814: BEGIN
815: l_func_name := g_package_name || 'get_application_id(short_name)';
816: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',l_func_name,NULL);
817: SELECT application_id

Line 819: FROM fnd_application

815: l_func_name := g_package_name || 'get_application_id(short_name)';
816: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',l_func_name,NULL);
817: SELECT application_id
818: INTO l_application_id
819: FROM fnd_application
820: WHERE application_short_name = p_application_short_name;
821: RETURN l_application_id;
822: EXCEPTION
823: WHEN OTHERS THEN

Line 839: l_application_id fnd_application.application_id%TYPE;

835: x_dff_flx OUT nocopy dff_flx_type)
836: RETURN BOOLEAN
837: IS
838: l_func_name VARCHAR2(80);
839: l_application_id fnd_application.application_id%TYPE;
840:
841: BEGIN
842: l_func_name := g_package_name || 'get_dff_flx(F)';
843: hr_utility.trace('get_dff_flx :p_descriptive_flexfield_name '||p_descriptive_flexfield_name);

Line 1007: fnd_application fa

1003: SELECT request_id
1004: INTO l_request_id
1005: FROM fnd_concurrent_requests fcr,
1006: fnd_concurrent_programs fcp,
1007: fnd_application fa
1008: WHERE fa.application_short_name = p_application_short_name
1009: AND fcp.application_id = fa.application_id
1010: AND fcp.concurrent_program_name = p_concurrent_program_name
1011: AND fcr.program_application_id = fcp.application_id