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.PV_PARTNER_PROGRAM_PVT dependencies on DUAL

Line 123: FROM dual

119: FUNCTION check_price_exists(p_program_id IN NUMBER)
120: RETURN VARCHAR2 IS
121: CURSOR get_price_line_details(p_program_id number) is
122: SELECT 'Y'
123: FROM dual
124: WHERE
125: EXISTS
126: (SELECT 1
127: FROM qp_list_attributes_v attr,pv_partner_program_b prg

Line 170: FROM dual

166: FUNCTION check_inventory_item_exists(p_program_id IN NUMBER)
167: RETURN VARCHAR2 IS
168: CURSOR is_inventory_item_exists(p_program_id number) is
169: SELECT 'Y'
170: FROM dual
171: WHERE
172: EXISTS
173: (SELECT 1
174: FROM pv_partner_program_b

Line 748: select 'X' from dual where exists

744: FUNCTION isApproverExists (p_program_type_id in number) return boolean is
745: l_temp varchar2(1);
746: isavailable boolean:=false ;
747: cursor app_cur(p_prgm_type_id varchar) is
748: select 'X' from dual where exists
749: (select approver_id from ams_approvers appr,ams_approval_details apdt
750: where nvl(appr.start_date_active,sysdate)<=sysdate
751: and nvl(appr.end_date_active,sysdate)>=sysdate
752: and appr.ams_approval_detail_id =apdt.approval_detail_id

Line 781: select 'X' from dual where exists

777: /*FUNCTION isEnrollApproverValid (p_program_id in number,p_end_date Date) return boolean is
778: l_temp varchar2(1);
779: isavailable boolean:=false ;
780: cursor enr_cur(p_prgm_id varchar,edate Date) is
781: select 'X' from dual where exists
782: (select approver_id from ams_approvers appr,ams_approval_details apdt
783: where nvl(appr.end_date_active,sysdate)>=edate
784: and appr.ams_approval_detail_id =apdt.approval_detail_id
785: and apdt.approval_object_type=p_prgm_id

Line 811: select 'X' from dual where exists (

807: FUNCTION isProgramDeletable (p_program_id in number) return boolean is
808: l_temp varchar2(1);
809: isDeletable boolean:=true ;
810: cursor rec_cur(p_prgm_id number) is
811: select 'X' from dual where exists (
812: select program_id from pv_partner_program_b
813: where program_parent_id=p_prgm_id
814: and enabled_flag='Y');
815: BEGIN

Line 933: select 'X' from dual where exists(

929:
930: l_status varchar2(1);
931: isCancellable boolean:=true;
932: cursor childprogramstatus_cur(p_prgm_id number) is
933: select 'X' from dual where exists(
934: select PROGRAM_STATUS_CODE from pv_partner_program_b where program_parent_id=p_prgm_id
935: and PROGRAM_STATUS_CODE not in('CANCEL','CLOSED','ARCHIVE') and enabled_flag='Y' );
936:
937: BEGIN

Line 1023: FROM dual;

1019: l_currency VARCHAR2(60);
1020: -- Cursor to get the sequence for pv_partner_program_b
1021: CURSOR c_partner_program_id_seq IS
1022: SELECT PV_PARTNER_PROGRAM_B_S.NEXTVAL
1023: FROM dual;
1024:
1025: -- Cursor to validate the uniqueness
1026: CURSOR c_partner_program_id_exists(l_id IN NUMBER) IS
1027: SELECT 'X'

Line 2913: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1

2909:
2910: IS
2911:
2912: CURSOR c_resource_exists IS
2913: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1
2914: FROM JTF_RS_RESOURCE_EXTNS
2915: WHERE RESOURCE_ID = p_ptr_prgm_rec.program_owner_resource_id
2916: AND NVL(end_date_active,SYSDATE) >= SYSDATE AND NVL(start_date_active, SYSDATE) <= SYSDATE);
2917:

Line 2920: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1

2916: AND NVL(end_date_active,SYSDATE) >= SYSDATE AND NVL(start_date_active, SYSDATE) <= SYSDATE);
2917:
2918: l_process_type VARCHAR2(4000) := 'PARTNER_PROGRAM';
2919: CURSOR c_pr_exists IS
2920: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1
2921: FROM pv_process_rules_vl pvprv
2922: WHERE PROCESS_RULE_ID = p_ptr_prgm_rec.process_rule_id
2923: AND NVL(start_date,SYSDATE) <= SYSDATE and NVL(end_date,SYSDATE) >= SYSDATE AND PROCESS_TYPE = l_process_type);
2924:

Line 2926: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1

2922: WHERE PROCESS_RULE_ID = p_ptr_prgm_rec.process_rule_id
2923: AND NVL(start_date,SYSDATE) <= SYSDATE and NVL(end_date,SYSDATE) >= SYSDATE AND PROCESS_TYPE = l_process_type);
2924:
2925: CURSOR c_pr_exists_1 IS
2926: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1
2927: FROM pv_process_rules_vl pvprv
2928: WHERE PROCESS_RULE_ID = p_ptr_prgm_rec.prereq_process_rule_id
2929: AND NVL(start_date,SYSDATE) <= SYSDATE and NVL(end_date,SYSDATE) >= SYSDATE AND PROCESS_TYPE = l_process_type);
2930: