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_TERR_ASSIGN_PUB dependencies on PV_TAP_BATCH_CHG_PARTNERS

Line 2995: -- PV_TAP_BATCH_CHG_PARTNERS table or not.

2991: l_processed_flag VARCHAR2(1) := 'P';
2992: l_object_version_number NUMBER ;
2993:
2994: -- Cursor l_chk_partner_exist_csr to check whether given partner_id exists in
2995: -- PV_TAP_BATCH_CHG_PARTNERS table or not.
2996: CURSOR l_chk_partner_exist_csr (cv_partner_id IN NUMBER) IS
2997: SELECT processed_flag, object_version_number
2998: FROM PV_TAP_BATCH_CHG_PARTNERS
2999: WHERE partner_id = cv_partner_id;

Line 2998: FROM PV_TAP_BATCH_CHG_PARTNERS

2994: -- Cursor l_chk_partner_exist_csr to check whether given partner_id exists in
2995: -- PV_TAP_BATCH_CHG_PARTNERS table or not.
2996: CURSOR l_chk_partner_exist_csr (cv_partner_id IN NUMBER) IS
2997: SELECT processed_flag, object_version_number
2998: FROM PV_TAP_BATCH_CHG_PARTNERS
2999: WHERE partner_id = cv_partner_id;
3000:
3001: -- Get the value of Profile PV_TAP_ASSIGN_ONLINE.
3002: CURSOR l_get_tap_prfl_value_csr(cv_profile_name IN VARCHAR2) IS

Line 3119: -- Check if the supplied partner_id already exist in PV_TAP_BATCH_CHG_PARTNERS table

3115: l_changed_partner_rec.partner_id := l_partner_id;
3116: l_changed_partner_rec.vad_partner_id := p_vad_partner_id;
3117: l_changed_partner_rec.processed_flag := 'P';
3118:
3119: -- Check if the supplied partner_id already exist in PV_TAP_BATCH_CHG_PARTNERS table
3120: -- then do not insert the record for that partner_id.
3121: OPEN l_chk_partner_exist_csr(l_partner_id);
3122: FETCH l_chk_partner_exist_csr INTO l_processed_flag, l_object_version_number;
3123:

Line 3128: -- to create a record in PV_TAP_BATCH_CHG_PARTNERS table.

3124: IF (l_chk_partner_exist_csr%NOTFOUND ) THEN
3125:
3126: CLOSE l_chk_partner_exist_csr;
3127: -- Call the Create_Batch_Chg_Partners API from PV_BATCH_CHG_PRTNR_PVT
3128: -- to create a record in PV_TAP_BATCH_CHG_PARTNERS table.
3129:
3130: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
3131: p_api_version_number => 1.0
3132: ,p_init_msg_list => FND_API.G_FALSE

Line 5438: -- from PV_TAP_BATCH_CHG_PARTNERS table to delete them from the table, if running mode is TOTAL

5434: l_object_version_number NUMBER;
5435: l_active_partner VARCHAR2(1) := 'N';
5436:
5437: -- Cursor to select all partner_id's between cv_first_partner_id and cv_last_partner_id
5438: -- from PV_TAP_BATCH_CHG_PARTNERS table to delete them from the table, if running mode is TOTAL
5439: CURSOR l_batch_partners_csr(cv_first_partner_id NUMBER, cv_last_partner_id NUMBER) IS
5440: SELECT partner_id , object_version_number
5441: FROM PV_TAP_BATCH_CHG_PARTNERS
5442: WHERE PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id;

Line 5441: FROM PV_TAP_BATCH_CHG_PARTNERS

5437: -- Cursor to select all partner_id's between cv_first_partner_id and cv_last_partner_id
5438: -- from PV_TAP_BATCH_CHG_PARTNERS table to delete them from the table, if running mode is TOTAL
5439: CURSOR l_batch_partners_csr(cv_first_partner_id NUMBER, cv_last_partner_id NUMBER) IS
5440: SELECT partner_id , object_version_number
5441: FROM PV_TAP_BATCH_CHG_PARTNERS
5442: WHERE PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id;
5443:
5444: -- Cursor to select all the partner_id's between cv_first_partner_id and cv_last_partner_id
5445: -- from PV_TAP_BATCH_CHG_PARTNERS table for channel team re-assignment in case of INCREMENTAL mode.

Line 5445: -- from PV_TAP_BATCH_CHG_PARTNERS table for channel team re-assignment in case of INCREMENTAL mode.

5441: FROM PV_TAP_BATCH_CHG_PARTNERS
5442: WHERE PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id;
5443:
5444: -- Cursor to select all the partner_id's between cv_first_partner_id and cv_last_partner_id
5445: -- from PV_TAP_BATCH_CHG_PARTNERS table for channel team re-assignment in case of INCREMENTAL mode.
5446: CURSOR l_chng_prtnrs_csr(cv_first_partner_id NUMBER, cv_last_partner_id NUMBER) IS
5447: /*
5448: SELECT partner_id, vad_partner_id, object_version_number,created_by
5449: FROM PV_TAP_BATCH_CHG_PARTNERS

Line 5449: FROM PV_TAP_BATCH_CHG_PARTNERS

5445: -- from PV_TAP_BATCH_CHG_PARTNERS table for channel team re-assignment in case of INCREMENTAL mode.
5446: CURSOR l_chng_prtnrs_csr(cv_first_partner_id NUMBER, cv_last_partner_id NUMBER) IS
5447: /*
5448: SELECT partner_id, vad_partner_id, object_version_number,created_by
5449: FROM PV_TAP_BATCH_CHG_PARTNERS
5450: WHERE PROCESSED_FLAG = 'P'
5451: AND PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id;
5452: */
5453: --New

Line 5455: FROM PV_TAP_BATCH_CHG_PARTNERS ptbcp,

5451: AND PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id;
5452: */
5453: --New
5454: SELECT hzp.party_name partner_name,ptbcp.partner_id, ptbcp.vad_partner_id, ptbcp.object_version_number,ptbcp.created_by
5455: FROM PV_TAP_BATCH_CHG_PARTNERS ptbcp,
5456: PV_PARTNER_PROFILES ppp,
5457: HZ_PARTIES hzp
5458: WHERE ptbcp.PROCESSED_FLAG = 'P'
5459: -- AND ptbcp.PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id

Line 5580: -- Create an error record in PV_TAP_BATCH_CHG_PARTNERS table with following

5576: END IF;
5577: END IF;
5578:
5579: IF ( l_mode = 'TOTAL' ) THEN
5580: -- Create an error record in PV_TAP_BATCH_CHG_PARTNERS table with following
5581: -- Concurrent request related attribute values
5582: -- * REQUEST_ID
5583: -- * PROGRAM_APPLICATION_ID
5584: -- * PROGRAM_ID

Line 5618: -- Update the PV_TAP_BATCH_CHG_PARTNERS table for following

5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5615: END IF;
5616: END IF;
5617: ELSIF ( l_mode = 'INCREMENTAL' ) THEN
5618: -- Update the PV_TAP_BATCH_CHG_PARTNERS table for following
5619: -- Concurrent request related attribute values
5620: -- * REQUEST_ID
5621: -- * PROGRAM_APPLICATION_ID
5622: -- * PROGRAM_ID

Line 5824: -- Cursor to select count of all the partner_id's from PV_TAP_BATCH_CHG_PARTNERS table

5820: p_first_partner_id IN NUMBER,
5821: p_last_partner_id IN NUMBER
5822: )
5823: IS
5824: -- Cursor to select count of all the partner_id's from PV_TAP_BATCH_CHG_PARTNERS table
5825: -- for channel team re-assignment in case of INCREMENTAL mode.
5826: CURSOR l_change_partners_count_csr IS
5827: SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ count(*)
5828: FROM PV_TAP_BATCH_CHG_PARTNERS

Line 5827: SELECT /+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) / count(*)

5823: IS
5824: -- Cursor to select count of all the partner_id's from PV_TAP_BATCH_CHG_PARTNERS table
5825: -- for channel team re-assignment in case of INCREMENTAL mode.
5826: CURSOR l_change_partners_count_csr IS
5827: SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ count(*)
5828: FROM PV_TAP_BATCH_CHG_PARTNERS
5829: WHERE PROCESSED_FLAG = 'P' ;
5830:
5831: -- Cursor to select all count of all the partner_id's from PV_PARTNER_PROFILES table

Line 5828: FROM PV_TAP_BATCH_CHG_PARTNERS

5824: -- Cursor to select count of all the partner_id's from PV_TAP_BATCH_CHG_PARTNERS table
5825: -- for channel team re-assignment in case of INCREMENTAL mode.
5826: CURSOR l_change_partners_count_csr IS
5827: SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ count(*)
5828: FROM PV_TAP_BATCH_CHG_PARTNERS
5829: WHERE PROCESSED_FLAG = 'P' ;
5830:
5831: -- Cursor to select all count of all the partner_id's from PV_PARTNER_PROFILES table
5832: -- for channel team re-assignment in case of TOTAL mode.

Line 5838: -- Cursor to select single partner_id from PV_TAP_BATCH_CHG_PARTNERS table

5834: SELECT count(*)
5835: FROM PV_PARTNER_PROFILES
5836: WHERE STATUS = 'A' ;
5837:
5838: -- Cursor to select single partner_id from PV_TAP_BATCH_CHG_PARTNERS table
5839: -- for channel team re-assignment in case if only one partner exist.
5840: CURSOR l_single_batch_partner_csr IS
5841: SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ partner_id
5842: FROM PV_TAP_BATCH_CHG_PARTNERS

Line 5841: SELECT /+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) / partner_id

5837:
5838: -- Cursor to select single partner_id from PV_TAP_BATCH_CHG_PARTNERS table
5839: -- for channel team re-assignment in case if only one partner exist.
5840: CURSOR l_single_batch_partner_csr IS
5841: SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ partner_id
5842: FROM PV_TAP_BATCH_CHG_PARTNERS
5843: WHERE PROCESSED_FLAG = 'P' ;
5844:
5845: -- Cursor to select single partner_id from PV_PARTNER_PROFILES table

Line 5842: FROM PV_TAP_BATCH_CHG_PARTNERS

5838: -- Cursor to select single partner_id from PV_TAP_BATCH_CHG_PARTNERS table
5839: -- for channel team re-assignment in case if only one partner exist.
5840: CURSOR l_single_batch_partner_csr IS
5841: SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ partner_id
5842: FROM PV_TAP_BATCH_CHG_PARTNERS
5843: WHERE PROCESSED_FLAG = 'P' ;
5844:
5845: -- Cursor to select single partner_id from PV_PARTNER_PROFILES table
5846: -- for channel team re-assignment in case if only one partner exist.

Line 5852: -- Cursor to select partner_id's in batches from PV_TAP_BATCH_CHG_PARTNERS table

5848: SELECT partner_id
5849: FROM PV_PARTNER_PROFILES
5850: WHERE STATUS = 'A' ;
5851:
5852: -- Cursor to select partner_id's in batches from PV_TAP_BATCH_CHG_PARTNERS table
5853: -- for channel team re-assignment in case of INCREMENTAL mode based on batch size.
5854: CURSOR l_change_partners_csr(cv_batch_size NUMBER) IS
5855: SELECT first.f,decode(last.l,null,(SELECT max(partner_id)
5856: FROM PV_TAP_BATCH_CHG_PARTNERS

Line 5856: FROM PV_TAP_BATCH_CHG_PARTNERS

5852: -- Cursor to select partner_id's in batches from PV_TAP_BATCH_CHG_PARTNERS table
5853: -- for channel team re-assignment in case of INCREMENTAL mode based on batch size.
5854: CURSOR l_change_partners_csr(cv_batch_size NUMBER) IS
5855: SELECT first.f,decode(last.l,null,(SELECT max(partner_id)
5856: FROM PV_TAP_BATCH_CHG_PARTNERS
5857: WHERE partner_id >= first.f
5858: AND PROCESSED_FLAG = 'P'
5859: AND last.l is null),last.l) la
5860: FROM

Line 5863: FROM ( SELECT /+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) / partner_id

5859: AND last.l is null),last.l) la
5860: FROM
5861: (SELECT decode(mod(rn,cv_batch_size),1,partner_id,null) f,null last,rownum rn
5862: FROM ( SELECT PARTNER_ID,ROWNUM RN
5863: FROM ( SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ partner_id
5864: FROM PV_TAP_BATCH_CHG_PARTNERS
5865: WHERE PROCESSED_FLAG = 'P'
5866: ORDER BY partner_id asc ) )
5867: WHERE decode(mod(rn,cv_batch_size),1,partner_id,null) IS NOT null ) first,

Line 5864: FROM PV_TAP_BATCH_CHG_PARTNERS

5860: FROM
5861: (SELECT decode(mod(rn,cv_batch_size),1,partner_id,null) f,null last,rownum rn
5862: FROM ( SELECT PARTNER_ID,ROWNUM RN
5863: FROM ( SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ partner_id
5864: FROM PV_TAP_BATCH_CHG_PARTNERS
5865: WHERE PROCESSED_FLAG = 'P'
5866: ORDER BY partner_id asc ) )
5867: WHERE decode(mod(rn,cv_batch_size),1,partner_id,null) IS NOT null ) first,
5868: (SELECT null first,decode(mod(rn,cv_batch_size),0,partner_id,null) l,rownum rn

Line 5870: FROM ( SELECT /+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) / partner_id

5866: ORDER BY partner_id asc ) )
5867: WHERE decode(mod(rn,cv_batch_size),1,partner_id,null) IS NOT null ) first,
5868: (SELECT null first,decode(mod(rn,cv_batch_size),0,partner_id,null) l,rownum rn
5869: FROM ( SELECT PARTNER_ID,ROWNUM RN
5870: FROM ( SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ partner_id
5871: FROM PV_TAP_BATCH_CHG_PARTNERS
5872: WHERE PROCESSED_FLAG = 'P'
5873: ORDER BY partner_id asc) )
5874: WHERE decode(mod(rn,cv_batch_size),0,partner_id,null) is not null) last

Line 5871: FROM PV_TAP_BATCH_CHG_PARTNERS

5867: WHERE decode(mod(rn,cv_batch_size),1,partner_id,null) IS NOT null ) first,
5868: (SELECT null first,decode(mod(rn,cv_batch_size),0,partner_id,null) l,rownum rn
5869: FROM ( SELECT PARTNER_ID,ROWNUM RN
5870: FROM ( SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ partner_id
5871: FROM PV_TAP_BATCH_CHG_PARTNERS
5872: WHERE PROCESSED_FLAG = 'P'
5873: ORDER BY partner_id asc) )
5874: WHERE decode(mod(rn,cv_batch_size),0,partner_id,null) is not null) last
5875: WHERE first.rn=last.rn(+);

Line 6171: -- Cursor to select all partner_id's from PV_TAP_BATCH_CHG_PARTNERS table

6167: l_partner_list_tbl partner_list_tbl_type ;
6168: l_partner_name VARCHAR2(360);
6169:
6170:
6171: -- Cursor to select all partner_id's from PV_TAP_BATCH_CHG_PARTNERS table
6172: -- to delete them from the table, if running mode is TOTAL
6173: CURSOR l_batch_partners_csr(cv_partner_id NUMBER) IS
6174: SELECT partner_id , object_version_number
6175: FROM PV_TAP_BATCH_CHG_PARTNERS

Line 6175: FROM PV_TAP_BATCH_CHG_PARTNERS

6171: -- Cursor to select all partner_id's from PV_TAP_BATCH_CHG_PARTNERS table
6172: -- to delete them from the table, if running mode is TOTAL
6173: CURSOR l_batch_partners_csr(cv_partner_id NUMBER) IS
6174: SELECT partner_id , object_version_number
6175: FROM PV_TAP_BATCH_CHG_PARTNERS
6176: WHERE partner_id = cv_partner_id;
6177:
6178: -- Cursor to select all the partner_id's from PV_TAP_BATCH_CHG_PARTNERS table
6179: -- for channel team re-assignment in case of INCREMENTAL mode.

Line 6178: -- Cursor to select all the partner_id's from PV_TAP_BATCH_CHG_PARTNERS table

6174: SELECT partner_id , object_version_number
6175: FROM PV_TAP_BATCH_CHG_PARTNERS
6176: WHERE partner_id = cv_partner_id;
6177:
6178: -- Cursor to select all the partner_id's from PV_TAP_BATCH_CHG_PARTNERS table
6179: -- for channel team re-assignment in case of INCREMENTAL mode.
6180: CURSOR l_terr_chng_prtnrs_csr(
6181: cv_terr_id1 NUMBER, cv_terr_id2 NUMBER,
6182: cv_terr_id3 NUMBER, cv_terr_id4 NUMBER,

Line 6205: -- Cursor to select all the partner_id's from PV_TAP_BATCH_CHG_PARTNERS table

6201: cv_terr_id9, cv_terr_id10, cv_terr_id11, cv_terr_id12,
6202: cv_terr_id13, cv_terr_id14, cv_terr_id15, cv_terr_id16,
6203: cv_terr_id17, cv_terr_id18, cv_terr_id19, cv_terr_id20);
6204:
6205: -- Cursor to select all the partner_id's from PV_TAP_BATCH_CHG_PARTNERS table
6206: -- for channel team re-assignment in case of INCREMENTAL mode.
6207: CURSOR l_chk_partner_exists_csr(cv_partner_id IN NUMBER )IS
6208: SELECT object_version_number
6209: FROM PV_TAP_BATCH_CHG_PARTNERS

Line 6209: FROM PV_TAP_BATCH_CHG_PARTNERS

6205: -- Cursor to select all the partner_id's from PV_TAP_BATCH_CHG_PARTNERS table
6206: -- for channel team re-assignment in case of INCREMENTAL mode.
6207: CURSOR l_chk_partner_exists_csr(cv_partner_id IN NUMBER )IS
6208: SELECT object_version_number
6209: FROM PV_TAP_BATCH_CHG_PARTNERS
6210: WHERE partner_id = cv_partner_id
6211: AND processed_flag = 'P';
6212:
6213: -- Cursor to select partner detail for the given partner_id's from

Line 6286: -- PV_TAP_BATCH_CHG_PARTNERS table.

6282: END IF;
6283: END IF;
6284:
6285: -- Check, whether that non-processed PARTNER_ID already exists in
6286: -- PV_TAP_BATCH_CHG_PARTNERS table.
6287: -- IF it exists, THEN
6288: -- UPDATE the record for that PARTNER_ID with the appropriate PROCESSED_FLAG status.
6289: -- ELSE
6290: -- CREATE a record for that PARTNER_ID with the appropriate PROCESSED_FLAG status.

Line 6298: -- Create an error record in PV_TAP_BATCH_CHG_PARTNERS table with following

6294: FETCH l_batch_partners_csr INTO lv_partner_id, l_object_version_number;
6295:
6296: IF ( l_batch_partners_csr%NOTFOUND ) THEN
6297: CLOSE l_batch_partners_csr;
6298: -- Create an error record in PV_TAP_BATCH_CHG_PARTNERS table with following
6299: -- Concurrent request related attribute values
6300: -- * REQUEST_ID
6301: -- * PROGRAM_APPLICATION_ID
6302: -- * PROGRAM_ID

Line 6340: -- Update the PV_TAP_BATCH_CHG_PARTNERS table for following

6336: END IF;
6337: END IF;
6338: ELSIF ( l_batch_partners_csr%FOUND ) THEN
6339: CLOSE l_batch_partners_csr;
6340: -- Update the PV_TAP_BATCH_CHG_PARTNERS table for following
6341: -- Concurrent request related attribute values
6342: -- * REQUEST_ID
6343: -- * PROGRAM_APPLICATION_ID
6344: -- * PROGRAM_ID