DBA Data[Home] [Help]

APPS.CLN_NP_PROCESSOR_PKG dependencies on FND_APPLICATION_VL

Line 506: -- Query fnd_application_vl for application name using application id

502: END IF;
503:
504: END IF;
505:
506: -- Query fnd_application_vl for application name using application id
507: BEGIN
508: SELECT application_name INTO l_application_name
509: FROM fnd_application_vl
510: WHERE application_id = l_application_id;

Line 509: FROM fnd_application_vl

505:
506: -- Query fnd_application_vl for application name using application id
507: BEGIN
508: SELECT application_name INTO l_application_name
509: FROM fnd_application_vl
510: WHERE application_id = l_application_id;
511: IF (l_Debug_Level <= 1) THEN
512: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);
513: ecx_cln_debug_pub.Add('l_application_name:' || l_application_name, 1);

Line 512: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);

508: SELECT application_name INTO l_application_name
509: FROM fnd_application_vl
510: WHERE application_id = l_application_id;
511: IF (l_Debug_Level <= 1) THEN
512: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);
513: ecx_cln_debug_pub.Add('l_application_name:' || l_application_name, 1);
514: END IF;
515:
516: EXCEPTION

Line 1922: -- Query fnd_application_vl for application name using application id

1918: ecx_cln_debug_pub.Add('Getting the Application Name from the Application ID as '||l_application_id, 1);
1919: END IF;
1920:
1921:
1922: -- Query fnd_application_vl for application name using application id
1923: BEGIN
1924: SELECT application_name
1925: INTO l_application_name
1926: FROM fnd_application_vl

Line 1926: FROM fnd_application_vl

1922: -- Query fnd_application_vl for application name using application id
1923: BEGIN
1924: SELECT application_name
1925: INTO l_application_name
1926: FROM fnd_application_vl
1927: WHERE application_id = l_application_id;
1928:
1929: IF (l_Debug_Level <= 1) THEN
1930: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);

Line 1930: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);

1926: FROM fnd_application_vl
1927: WHERE application_id = l_application_id;
1928:
1929: IF (l_Debug_Level <= 1) THEN
1930: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);
1931: ecx_cln_debug_pub.Add('APPLICATION NAME ----- >>>'||l_application_name, 1);
1932: END IF;
1933:
1934: EXCEPTION