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 PV_PARTNER_PROGRAM_B

Line 127: FROM qp_list_attributes_v attr,pv_partner_program_b prg

123: FROM dual
124: WHERE
125: EXISTS
126: (SELECT 1
127: FROM qp_list_attributes_v attr,pv_partner_program_b prg
128: WHERE prg.program_id = p_program_id
129: AND attr.PRODUCT_ATTR_VALUE = to_char(prg.inventory_item_id)
130: AND attr.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
131: AND attr.PRODUCT_ATTRIBUTE ='PRICING_ATTRIBUTE1'

Line 174: FROM pv_partner_program_b

170: FROM dual
171: WHERE
172: EXISTS
173: (SELECT 1
174: FROM pv_partner_program_b
175: WHERE program_id = p_program_id
176: AND INVENTORY_ITEM_ID is not null
177: AND INVENTORY_ITEM_ORG_ID is not null
178: );

Line 198: FROM pv_partner_program_b

194: FUNCTION check_membership_duration(p_program_id IN NUMBER)
195: RETURN VARCHAR2 IS
196: CURSOR get_memb_dur( p_program_id number ) IS
197: select membership_period_unit,membership_valid_period
198: FROM pv_partner_program_b
199: WHERE program_id=p_program_id;
200: l_exists_flag VARCHAR2(1) := 'Y';
201: l_membership_period_unit VARCHAR2(15);
202: l_membership_valid_period NUMBER;

Line 812: select program_id from pv_partner_program_b

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
816: OPEN rec_cur(p_program_id);

Line 837: select program_start_date,program_end_date from pv_partner_program_b where program_id=p_parent_prgm_id;

833: l_parent_program_start_date Date;
834: l_parent_program_end_date Date;
835: isDatesInRange boolean:=false ;
836: cursor startend_cur(p_parent_prgm_id number) is
837: select program_start_date,program_end_date from pv_partner_program_b where program_id=p_parent_prgm_id;
838: BEGIN
839: OPEN startend_cur(p_parent_program_id);
840: FETCH startend_cur into l_parent_program_start_date,l_parent_program_end_date;
841: if startend_cur%found THEN

Line 881: select PROGRAM_STATUS_CODE from pv_partner_program_b where program_id=p_parent_prgm_id;

877:
878: l_parent_program_status varchar2(30);
879: isActivatable boolean:=false ;
880: cursor parentprogramstatus_cur(p_parent_prgm_id number) is
881: select PROGRAM_STATUS_CODE from pv_partner_program_b where program_id=p_parent_prgm_id;
882: BEGIN
883: OPEN parentprogramstatus_cur(p_parent_program_id);
884: FETCH parentprogramstatus_cur into l_parent_program_status;
885: if parentprogramstatus_cur%found THEN

Line 906: select PROGRAM_STATUS_CODE from pv_partner_program_b where program_id=p_parent_prgm_id;

902:
903: l_parent_program_status varchar2(30);
904: isApproved boolean:=false ;
905: cursor parentprogramstatus_cur(p_parent_prgm_id number) is
906: select PROGRAM_STATUS_CODE from pv_partner_program_b where program_id=p_parent_prgm_id;
907: BEGIN
908: OPEN parentprogramstatus_cur(p_parent_program_id);
909: FETCH parentprogramstatus_cur into l_parent_program_status;
910: if parentprogramstatus_cur%found THEN

Line 934: select PROGRAM_STATUS_CODE from pv_partner_program_b where program_parent_id=p_prgm_id

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
938:

Line 1020: -- Cursor to get the sequence for pv_partner_program_b

1016: l_dummy_id NUMBER ;
1017: l_start_end_date_within_range boolean :=false;
1018: l_isNoEnrlDateInRange boolean:=true;
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:

Line 1022: SELECT PV_PARTNER_PROGRAM_B_S.NEXTVAL

1018: l_isNoEnrlDateInRange boolean:=true;
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

Line 1028: FROM PV_PARTNER_PROGRAM_B

1024:
1025: -- Cursor to validate the uniqueness
1026: CURSOR c_partner_program_id_exists(l_id IN NUMBER) IS
1027: SELECT 'X'
1028: FROM PV_PARTNER_PROGRAM_B
1029: WHERE PROGRAM_ID = l_id;
1030:
1031: CURSOR c_resource_id(p_user_id IN NUMBER) IS
1032: SELECT RESOURCE_ID

Line 1721: FROM PV_PARTNER_PROGRAM_B

1717:
1718:
1719: CURSOR c_get_partner_program(cv_program_id NUMBER) IS
1720: SELECT *
1721: FROM PV_PARTNER_PROGRAM_B
1722: WHERE PROGRAM_ID = cv_program_ID;
1723:
1724: CURSOR c_get_child_programs(cv_program_id NUMBER) IS
1725: SELECT program_id,object_version_number

Line 1726: FROM pv_partner_program_b

1722: WHERE PROGRAM_ID = cv_program_ID;
1723:
1724: CURSOR c_get_child_programs(cv_program_id NUMBER) IS
1725: SELECT program_id,object_version_number
1726: FROM pv_partner_program_b
1727: where program_id not in ( cv_program_id)
1728: and enabled_flag='Y'
1729: start with program_id = cv_program_id
1730: CONNECT BY PRIOR program_id = program_parent_id;

Line 2113: update pv_partner_program_b set submit_child_nodes='Y',object_version_number=c_rec.object_version_number+1 where program_id=c_rec.program_id;

2109: IF l_tar_ptr_prgm_rec.program_status_code='PENDING_APPROVAL' THEN
2110:
2111: IF l_tar_ptr_prgm_rec.submit_child_nodes='Y' THEN
2112: for c_rec in c_get_child_programs(l_tar_ptr_prgm_rec.program_id) loop
2113: update pv_partner_program_b set submit_child_nodes='Y',object_version_number=c_rec.object_version_number+1 where program_id=c_rec.program_id;
2114: end loop;
2115: END IF;
2116: IF (PV_DEBUG_HIGH_ON) THEN
2117:

Line 2256: FROM PV_PARTNER_PROGRAM_B

2252: IS
2253:
2254: CURSOR c_get_partner_program_rec(cv_program_id NUMBER) IS
2255: SELECT *
2256: FROM PV_PARTNER_PROGRAM_B
2257: WHERE PROGRAM_ID = cv_program_id;
2258:
2259: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Partner_Program';
2260: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 2459: FROM PV_PARTNER_PROGRAM_B

2455: l_program_id NUMBER;
2456:
2457: CURSOR c_Partner_Program IS
2458: SELECT PROGRAM_ID
2459: FROM PV_PARTNER_PROGRAM_B
2460: WHERE PROGRAM_ID = px_program_id
2461: AND object_version_number = p_object_version
2462: FOR UPDATE NOWAIT;
2463:

Line 2582: 'PV_PARTNER_PROGRAM_B',

2578: x_return_status := FND_API.g_ret_sts_success;
2579: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2580:
2581: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
2582: 'PV_PARTNER_PROGRAM_B',
2583: 'PROGRAM_ID = ''' || p_ptr_prgm_rec.PROGRAM_ID ||''''
2584: );
2585:
2586: IF l_valid_flag = FND_API.g_false THEN

Line 2602: 'PV_PARTNER_PROGRAM_B',

2598: END IF;
2599:
2600:
2601: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
2602: 'PV_PARTNER_PROGRAM_B',
2603: 'PROCESS_RULE_ID = ''' || p_ptr_prgm_rec.PROCESS_RULE_ID ||''''
2604: );
2605:
2606: IF l_valid_flag = FND_API.g_false THEN

Line 2622: 'PV_PARTNER_PROGRAM_B',

2618: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before prereq_process_rule_Id check' );
2619: END IF;
2620:
2621: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
2622: 'PV_PARTNER_PROGRAM_B',
2623: 'PREREQ_PROCESS_RULE_ID = ''' || p_ptr_prgm_rec.PREREQ_PROCESS_RULE_ID ||''''
2624: );
2625:
2626: IF l_valid_flag = FND_API.g_false THEN

Line 3824: FROM pv_partner_program_b

3820: RETCODE OUT NOCOPY VARCHAR2 )
3821: IS
3822: CURSOR c_get_closable_memb IS
3823: SELECT program_id, object_version_number
3824: FROM pv_partner_program_b
3825: WHERE program_level_code = 'MEMBERSHIP'
3826: AND NVL(program_end_date,sysdate+1) <= sysdate
3827: AND program_status_code NOT IN ('CLOSED', 'ARCHIVE');
3828:

Line 3831: FROM pv_partner_program_b

3827: AND program_status_code NOT IN ('CLOSED', 'ARCHIVE');
3828:
3829: CURSOR c_get_closable_prgm IS
3830: SELECT program_id, object_version_number
3831: FROM pv_partner_program_b
3832: WHERE program_level_code = 'PROGRAM'
3833: AND NVL(program_end_date,sysdate+1) <= sysdate
3834: AND program_status_code NOT IN ('CLOSED', 'ARCHIVE');
3835:

Line 4474: FROM pv_partner_program_b

4470: )
4471: IS
4472: CURSOR c_get_process_rule_id (cv_program_id IN NUMBER) IS
4473: SELECT process_rule_id id, 'ProcessRule' rule, object_version_number
4474: FROM pv_partner_program_b
4475: WHERE program_id = cv_program_id
4476: UNION
4477: SELECT prereq_process_rule_id id, 'PrereqProcessRule' rule, object_version_number
4478: FROM pv_partner_program_b

Line 4478: FROM pv_partner_program_b

4474: FROM pv_partner_program_b
4475: WHERE program_id = cv_program_id
4476: UNION
4477: SELECT prereq_process_rule_id id, 'PrereqProcessRule' rule, object_version_number
4478: FROM pv_partner_program_b
4479: WHERE program_id = cv_program_id;
4480:
4481: CURSOR c_get_process_rule_rec (cv_process_rule_id IN NUMBER) IS
4482: SELECT *

Line 4494: FROM pv_partner_program_b

4490:
4491: /*
4492: CURSOR c_get_object_version_number (cv_program_id IN NUMBER) IS
4493: SELECT object_version_number
4494: FROM pv_partner_program_b
4495: WHERE program_id = cv_program_id;
4496: */
4497: CURSOR c_get_pec_rules_rec (cv_program_id IN NUMBER) IS
4498: SELECT *

Line 4599: -- pv_partner_program_b table and delete it.

4595: END IF;
4596: END LOOP;
4597:
4598: -- Get the "fake" (created in create_partner_program) process_rule_id in
4599: -- pv_partner_program_b table and delete it.
4600: -- Also get the object_version_number of that program record for update
4601: -- later. (Update the process_rule_id with the l_return_rule_id)
4602: FOR x IN c_get_process_rule_id (p_tar_object_id)
4603: LOOP

Line 5720: -- Param p_update_program_table is to indicate whether to update PV_PARTNER_PROGRAM_B

5716: x_return_status := FND_API.G_RET_STS_SUCCESS;
5717:
5718: END create_prereqruleid;
5719:
5720: -- Param p_update_program_table is to indicate whether to update PV_PARTNER_PROGRAM_B
5721: -- If p_update_program_table is 'Y' update the invtory item id
5722: -- and orgnization id with the newly created inventory item info
5723: PROCEDURE create_inv_item_if_not_exists(
5724: p_api_version_number IN NUMBER