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.CN_PLAN_TEXTS_PVT dependencies on CN_SF_REPOSITORIES

Line 596: l_temp_con_title cn_sf_repositories.CONTRACT_TITLE%TYPE := NULL;

592: ORDER BY sequence_id;
593:
594: l_plan_text l_pts_cr%ROWTYPE;
595:
596: l_temp_con_title cn_sf_repositories.CONTRACT_TITLE%TYPE := NULL;
597: l_temp_term_con cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := NULL;
598: l_temp_club cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := NULL;
599: l_temp_app_name cn_sf_repositories.APPROVER_NAME%TYPE := NULL;
600: l_temp_app_title cn_sf_repositories.APPROVER_TITLE%TYPE := NULL;

Line 597: l_temp_term_con cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := NULL;

593:
594: l_plan_text l_pts_cr%ROWTYPE;
595:
596: l_temp_con_title cn_sf_repositories.CONTRACT_TITLE%TYPE := NULL;
597: l_temp_term_con cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := NULL;
598: l_temp_club cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := NULL;
599: l_temp_app_name cn_sf_repositories.APPROVER_NAME%TYPE := NULL;
600: l_temp_app_title cn_sf_repositories.APPROVER_TITLE%TYPE := NULL;
601: l_temp_app_org cn_sf_repositories.APPROVER_ORG_NAME%TYPE := NULL;

Line 598: l_temp_club cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := NULL;

594: l_plan_text l_pts_cr%ROWTYPE;
595:
596: l_temp_con_title cn_sf_repositories.CONTRACT_TITLE%TYPE := NULL;
597: l_temp_term_con cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := NULL;
598: l_temp_club cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := NULL;
599: l_temp_app_name cn_sf_repositories.APPROVER_NAME%TYPE := NULL;
600: l_temp_app_title cn_sf_repositories.APPROVER_TITLE%TYPE := NULL;
601: l_temp_app_org cn_sf_repositories.APPROVER_ORG_NAME%TYPE := NULL;
602:

Line 599: l_temp_app_name cn_sf_repositories.APPROVER_NAME%TYPE := NULL;

595:
596: l_temp_con_title cn_sf_repositories.CONTRACT_TITLE%TYPE := NULL;
597: l_temp_term_con cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := NULL;
598: l_temp_club cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := NULL;
599: l_temp_app_name cn_sf_repositories.APPROVER_NAME%TYPE := NULL;
600: l_temp_app_title cn_sf_repositories.APPROVER_TITLE%TYPE := NULL;
601: l_temp_app_org cn_sf_repositories.APPROVER_ORG_NAME%TYPE := NULL;
602:
603: BEGIN

Line 600: l_temp_app_title cn_sf_repositories.APPROVER_TITLE%TYPE := NULL;

596: l_temp_con_title cn_sf_repositories.CONTRACT_TITLE%TYPE := NULL;
597: l_temp_term_con cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := NULL;
598: l_temp_club cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := NULL;
599: l_temp_app_name cn_sf_repositories.APPROVER_NAME%TYPE := NULL;
600: l_temp_app_title cn_sf_repositories.APPROVER_TITLE%TYPE := NULL;
601: l_temp_app_org cn_sf_repositories.APPROVER_ORG_NAME%TYPE := NULL;
602:
603: BEGIN
604: -- Standard Start of API savepoint

Line 601: l_temp_app_org cn_sf_repositories.APPROVER_ORG_NAME%TYPE := NULL;

597: l_temp_term_con cn_sf_repositories.TERMS_AND_CONDITIONS%TYPE := NULL;
598: l_temp_club cn_sf_repositories.CLUB_QUAL_TEXT%TYPE := NULL;
599: l_temp_app_name cn_sf_repositories.APPROVER_NAME%TYPE := NULL;
600: l_temp_app_title cn_sf_repositories.APPROVER_TITLE%TYPE := NULL;
601: l_temp_app_org cn_sf_repositories.APPROVER_ORG_NAME%TYPE := NULL;
602:
603: BEGIN
604: -- Standard Start of API savepoint
605: SAVEPOINT Get_Plan_Texts;

Line 630: FROM cn_sf_repositories;

626: approver_title, approver_org_name
627: INTO l_temp_con_title, l_temp_term_con,
628: l_temp_club, l_temp_app_name,
629: l_temp_app_title, l_temp_app_org
630: FROM cn_sf_repositories;
631: EXCEPTION
632: WHEN No_Data_Found THEN
633: null;
634: END;