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.OKS_EXTWARPRGM_PVT dependencies on FND_GLOBAL

Line 3592: l_cpsv_tbl_in (1).user_id := fnd_global.user_id;

3588: IF p_k_header_rec.pdf_id IS NOT NULL
3589: THEN
3590: l_cpsv_tbl_in (1).pdf_id := p_k_header_rec.pdf_id;
3591: l_cpsv_tbl_in (1).chr_id := l_chrid;
3592: l_cpsv_tbl_in (1).user_id := fnd_global.user_id;
3593: l_cpsv_tbl_in (1).in_process_yn := okc_api.g_miss_char;
3594: l_cpsv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3595: l_cpsv_tbl_in (1).created_by := okc_api.g_miss_num;
3596: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;

Line 5342: l_cimv_tbl (1).created_by := fnd_global.user_id;

5338: l_cimv_tbl (1).priced_item_yn := '';
5339: l_cimv_tbl (1).upg_orig_system_ref := '';
5340: l_cimv_tbl (1).upg_orig_system_ref_id := NULL;
5341: l_cimv_tbl (1).object_version_number := 1;
5342: l_cimv_tbl (1).created_by := fnd_global.user_id;
5343: l_cimv_tbl (1).creation_date := SYSDATE;
5344: l_cimv_tbl (1).last_updated_by := fnd_global.user_id;
5345: l_cimv_tbl (1).last_update_date := SYSDATE;
5346: l_cimv_tbl (1).last_update_login := NULL;

Line 5344: l_cimv_tbl (1).last_updated_by := fnd_global.user_id;

5340: l_cimv_tbl (1).upg_orig_system_ref_id := NULL;
5341: l_cimv_tbl (1).object_version_number := 1;
5342: l_cimv_tbl (1).created_by := fnd_global.user_id;
5343: l_cimv_tbl (1).creation_date := SYSDATE;
5344: l_cimv_tbl (1).last_updated_by := fnd_global.user_id;
5345: l_cimv_tbl (1).last_update_date := SYSDATE;
5346: l_cimv_tbl (1).last_update_login := NULL;
5347: l_cimv_tbl (1).request_id := NULL;
5348: l_cimv_tbl (1).program_id := NULL;

Line 6262: || fnd_global.local_chr (10)

6258: WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19))
6259: WHERE ID = l_chrid;
6260:
6261: launch_workflow ( 'INSTALL BASE ACTIVITY : NEW '
6262: || fnd_global.local_chr (10)
6263: || 'Contract Number : '
6264: || get_contract_number (l_chrid)
6265: || fnd_global.local_chr (10)
6266: || 'Service Added : '

Line 6265: || fnd_global.local_chr (10)

6261: launch_workflow ( 'INSTALL BASE ACTIVITY : NEW '
6262: || fnd_global.local_chr (10)
6263: || 'Contract Number : '
6264: || get_contract_number (l_chrid)
6265: || fnd_global.local_chr (10)
6266: || 'Service Added : '
6267: || p_extwar_rec.srv_name
6268: || fnd_global.local_chr (10)
6269: || 'Customer Product : '

Line 6268: || fnd_global.local_chr (10)

6264: || get_contract_number (l_chrid)
6265: || fnd_global.local_chr (10)
6266: || 'Service Added : '
6267: || p_extwar_rec.srv_name
6268: || fnd_global.local_chr (10)
6269: || 'Customer Product : '
6270: || p_extwar_rec.lvl_cp_id
6271: );
6272: EXCEPTION

Line 7480: || fnd_global.local_chr (10)

7476: END IF;
7477: END IF;
7478:
7479: launch_workflow ( 'INSTALL BASE ACTIVITY : SPLIT '
7480: || fnd_global.local_chr (10)
7481: || 'Contract Number : '
7482: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
7483: || fnd_global.local_chr (10)
7484: || 'Splitted Cust Product : '

Line 7483: || fnd_global.local_chr (10)

7479: launch_workflow ( 'INSTALL BASE ACTIVITY : SPLIT '
7480: || fnd_global.local_chr (10)
7481: || 'Contract Number : '
7482: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
7483: || fnd_global.local_chr (10)
7484: || 'Splitted Cust Product : '
7485: || p_kdtl_tbl (l_ctr).old_cp_id
7486: || fnd_global.local_chr (10)
7487: || 'New Customer Product : '

Line 7486: || fnd_global.local_chr (10)

7482: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
7483: || fnd_global.local_chr (10)
7484: || 'Splitted Cust Product : '
7485: || p_kdtl_tbl (l_ctr).old_cp_id
7486: || fnd_global.local_chr (10)
7487: || 'New Customer Product : '
7488: || p_kdtl_tbl (l_ctr).new_cp_id
7489: );
7490: EXIT WHEN l_ctr = p_kdtl_tbl.LAST;

Line 8461: || fnd_global.local_chr (10)

8457: END IF;
8458: END IF;
8459:
8460: launch_workflow ( 'INSTALL BASE ACTIVITY : REPLACE '
8461: || fnd_global.local_chr (10)
8462: || 'Contract Number : '
8463: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
8464: || fnd_global.local_chr (10)
8465: || 'Old Cust Product : '

Line 8464: || fnd_global.local_chr (10)

8460: launch_workflow ( 'INSTALL BASE ACTIVITY : REPLACE '
8461: || fnd_global.local_chr (10)
8462: || 'Contract Number : '
8463: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
8464: || fnd_global.local_chr (10)
8465: || 'Old Cust Product : '
8466: || p_kdtl_tbl (l_ctr).old_cp_id
8467: || fnd_global.local_chr (10)
8468: || 'Replaced Cust Product : '

Line 8467: || fnd_global.local_chr (10)

8463: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
8464: || fnd_global.local_chr (10)
8465: || 'Old Cust Product : '
8466: || p_kdtl_tbl (l_ctr).old_cp_id
8467: || fnd_global.local_chr (10)
8468: || 'Replaced Cust Product : '
8469: || p_kdtl_tbl (l_ctr).new_cp_id
8470: );
8471: --END IF;

Line 9181: || fnd_global.local_chr (10)

9177:
9178: CLOSE l_serv_csr;
9179:
9180: launch_workflow ( 'INSTALL BASE ACTIVITY : RETURN '
9181: || fnd_global.local_chr (10)
9182: || 'Contract Number : '
9183: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
9184: || fnd_global.local_chr (10)
9185: || 'Service Terminated : '

Line 9184: || fnd_global.local_chr (10)

9180: launch_workflow ( 'INSTALL BASE ACTIVITY : RETURN '
9181: || fnd_global.local_chr (10)
9182: || 'Contract Number : '
9183: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
9184: || fnd_global.local_chr (10)
9185: || 'Service Terminated : '
9186: || l_service_name
9187: );
9188: EXIT WHEN l_ctr = p_kdtl_tbl.LAST;

Line 11229: || fnd_global.local_chr (10)

11225: END IF;
11226:
11227: launch_workflow
11228: ( 'INSTALL BASE ACTIVITY : TRANSFER TERMINATE SUBLINE '
11229: || fnd_global.local_chr (10)
11230: || 'Contract Number : '
11231: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
11232: || fnd_global.local_chr (10)
11233: || 'Service Terminated : '

Line 11232: || fnd_global.local_chr (10)

11228: ( 'INSTALL BASE ACTIVITY : TRANSFER TERMINATE SUBLINE '
11229: || fnd_global.local_chr (10)
11230: || 'Contract Number : '
11231: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
11232: || fnd_global.local_chr (10)
11233: || 'Service Terminated : '
11234: || l_service_name
11235: );
11236: ELSIF l_ste_code = 'ENTERED'

Line 11965: || fnd_global.local_chr (10)

11961: p_kdtl_tbl (l_ctr).hdr_sts;
11962: l_ptr := l_ptr + 1;
11963: launch_workflow
11964: ( 'INSTALL BASE ACTIVITY : TRANSFER TERMINATE SUBLINE '
11965: || fnd_global.local_chr (10)
11966: || 'Contract Number : '
11967: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
11968: || fnd_global.local_chr (10)
11969: || 'Service Terminated : '

Line 11968: || fnd_global.local_chr (10)

11964: ( 'INSTALL BASE ACTIVITY : TRANSFER TERMINATE SUBLINE '
11965: || fnd_global.local_chr (10)
11966: || 'Contract Number : '
11967: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
11968: || fnd_global.local_chr (10)
11969: || 'Service Terminated : '
11970: || l_service_name
11971: );
11972:

Line 12577: || fnd_global.local_chr (10)

12573: END IF;
12574:
12575: launch_workflow
12576: ( 'INSTALL BASE ACTIVITY : Transfer '
12577: || fnd_global.local_chr (10)
12578: || 'Contract Number : '
12579: || get_contract_number
12580: (l_merge_chr_id)
12581: || fnd_global.local_chr (10)

Line 12581: || fnd_global.local_chr (10)

12577: || fnd_global.local_chr (10)
12578: || 'Contract Number : '
12579: || get_contract_number
12580: (l_merge_chr_id)
12581: || fnd_global.local_chr (10)
12582: || 'Covered Product line merged into Contract : '
12583: || p_kdtl_tbl (l_ctr).old_cp_id
12584: );
12585: l_contract_merge := 'T';

Line 13112: || fnd_global.local_chr (10)

13108: END IF;
13109:
13110: launch_workflow
13111: ( 'INSTALL BASE ACTIVITY : TRANSFER '
13112: || fnd_global.local_chr (10)
13113: || 'Contract Number : '
13114: || get_contract_number (l_merge_chr_id)
13115: || fnd_global.local_chr (10)
13116: || 'Service line merged in to COntract : '

Line 13115: || fnd_global.local_chr (10)

13111: ( 'INSTALL BASE ACTIVITY : TRANSFER '
13112: || fnd_global.local_chr (10)
13113: || 'Contract Number : '
13114: || get_contract_number (l_merge_chr_id)
13115: || fnd_global.local_chr (10)
13116: || 'Service line merged in to COntract : '
13117: || l_service_name
13118: );
13119: l_contract_merge := 'T';

Line 13650: || fnd_global.local_chr (10)

13646: END IF;
13647:
13648: launch_workflow
13649: ( 'INSTALL BASE ACTIVITY : TRANSFER '
13650: || fnd_global.local_chr (10)
13651: || 'Contract Number : '
13652: || get_contract_number (l_chr_id)
13653: || fnd_global.local_chr (10)
13654: || 'New Contract Created : '

Line 13653: || fnd_global.local_chr (10)

13649: ( 'INSTALL BASE ACTIVITY : TRANSFER '
13650: || fnd_global.local_chr (10)
13651: || 'Contract Number : '
13652: || get_contract_number (l_chr_id)
13653: || fnd_global.local_chr (10)
13654: || 'New Contract Created : '
13655: || l_service_name
13656: );
13657: END IF;

Line 14379: || fnd_global.local_chr (10)

14375:
14376: CLOSE l_serv_csr;
14377:
14378: launch_workflow ( 'INSTALL BASE ACTIVITY : TERMINATE '
14379: || fnd_global.local_chr (10)
14380: || 'Contract Number : '
14381: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
14382: || fnd_global.local_chr (10)
14383: || 'Customer product end dated : '

Line 14382: || fnd_global.local_chr (10)

14378: launch_workflow ( 'INSTALL BASE ACTIVITY : TERMINATE '
14379: || fnd_global.local_chr (10)
14380: || 'Contract Number : '
14381: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
14382: || fnd_global.local_chr (10)
14383: || 'Customer product end dated : '
14384: || l_service_name
14385: );
14386: /* get_sts_code (NULL,

Line 15456: || fnd_global.local_chr (10)

15452: END IF;
15453:
15454: launch_workflow
15455: ( 'INSTALL BASE ACTIVITY : INSTALLTION DATE CHANGE '
15456: || fnd_global.local_chr (10)
15457: || 'Contract Number : '
15458: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
15459: || fnd_global.local_chr (10)
15460: || 'Inatallation date changed to : '

Line 15459: || fnd_global.local_chr (10)

15455: ( 'INSTALL BASE ACTIVITY : INSTALLTION DATE CHANGE '
15456: || fnd_global.local_chr (10)
15457: || 'Contract Number : '
15458: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
15459: || fnd_global.local_chr (10)
15460: || 'Inatallation date changed to : '
15461: || trunc(p_kdtl_tbl (l_ctr).installation_date)
15462: );
15463: EXIT WHEN l_ctr = p_kdtl_tbl.LAST;