DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on FND_GLOBAL

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

3659: IF p_k_header_rec.pdf_id IS NOT NULL
3660: THEN
3661: l_cpsv_tbl_in (1).pdf_id := p_k_header_rec.pdf_id;
3662: l_cpsv_tbl_in (1).chr_id := l_chrid;
3663: l_cpsv_tbl_in (1).user_id := fnd_global.user_id;
3664: l_cpsv_tbl_in (1).in_process_yn := okc_api.g_miss_char;
3665: l_cpsv_tbl_in (1).object_version_number := okc_api.g_miss_num;
3666: l_cpsv_tbl_in (1).created_by := okc_api.g_miss_num;
3667: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;

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

5506: l_cimv_tbl (1).priced_item_yn := '';
5507: l_cimv_tbl (1).upg_orig_system_ref := '';
5508: l_cimv_tbl (1).upg_orig_system_ref_id := NULL;
5509: l_cimv_tbl (1).object_version_number := 1;
5510: l_cimv_tbl (1).created_by := fnd_global.user_id;
5511: l_cimv_tbl (1).creation_date := SYSDATE;
5512: l_cimv_tbl (1).last_updated_by := fnd_global.user_id;
5513: l_cimv_tbl (1).last_update_date := SYSDATE;
5514: l_cimv_tbl (1).last_update_login := NULL;

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

5508: l_cimv_tbl (1).upg_orig_system_ref_id := NULL;
5509: l_cimv_tbl (1).object_version_number := 1;
5510: l_cimv_tbl (1).created_by := fnd_global.user_id;
5511: l_cimv_tbl (1).creation_date := SYSDATE;
5512: l_cimv_tbl (1).last_updated_by := fnd_global.user_id;
5513: l_cimv_tbl (1).last_update_date := SYSDATE;
5514: l_cimv_tbl (1).last_update_login := NULL;
5515: l_cimv_tbl (1).request_id := NULL;
5516: l_cimv_tbl (1).program_id := NULL;

Line 6430: || fnd_global.local_chr (10)

6426: WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19))
6427: WHERE ID = l_chrid;
6428:
6429: launch_workflow ( 'INSTALL BASE ACTIVITY : NEW '
6430: || fnd_global.local_chr (10)
6431: || 'Contract Number : '
6432: || get_contract_number (l_chrid)
6433: || fnd_global.local_chr (10)
6434: || 'Service Added : '

Line 6433: || fnd_global.local_chr (10)

6429: launch_workflow ( 'INSTALL BASE ACTIVITY : NEW '
6430: || fnd_global.local_chr (10)
6431: || 'Contract Number : '
6432: || get_contract_number (l_chrid)
6433: || fnd_global.local_chr (10)
6434: || 'Service Added : '
6435: || p_extwar_rec.srv_name
6436: || fnd_global.local_chr (10)
6437: || 'Customer Product : '

Line 6436: || fnd_global.local_chr (10)

6432: || get_contract_number (l_chrid)
6433: || fnd_global.local_chr (10)
6434: || 'Service Added : '
6435: || p_extwar_rec.srv_name
6436: || fnd_global.local_chr (10)
6437: || 'Customer Product : '
6438: || p_extwar_rec.lvl_cp_id
6439: );
6440: EXCEPTION

Line 7661: || fnd_global.local_chr (10)

7657: END IF;
7658: END IF;
7659:
7660: launch_workflow ( 'INSTALL BASE ACTIVITY : SPLIT '
7661: || fnd_global.local_chr (10)
7662: || 'Contract Number : '
7663: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
7664: || fnd_global.local_chr (10)
7665: || 'Splitted Cust Product : '

Line 7664: || fnd_global.local_chr (10)

7660: launch_workflow ( 'INSTALL BASE ACTIVITY : SPLIT '
7661: || fnd_global.local_chr (10)
7662: || 'Contract Number : '
7663: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
7664: || fnd_global.local_chr (10)
7665: || 'Splitted Cust Product : '
7666: || p_kdtl_tbl (l_ctr).old_cp_id
7667: || fnd_global.local_chr (10)
7668: || 'New Customer Product : '

Line 7667: || fnd_global.local_chr (10)

7663: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
7664: || fnd_global.local_chr (10)
7665: || 'Splitted Cust Product : '
7666: || p_kdtl_tbl (l_ctr).old_cp_id
7667: || fnd_global.local_chr (10)
7668: || 'New Customer Product : '
7669: || p_kdtl_tbl (l_ctr).new_cp_id
7670: );
7671: EXIT WHEN l_ctr = p_kdtl_tbl.LAST;

Line 8679: || fnd_global.local_chr (10)

8675: END IF;
8676: END IF;
8677:
8678: launch_workflow ( 'INSTALL BASE ACTIVITY : REPLACE '
8679: || fnd_global.local_chr (10)
8680: || 'Contract Number : '
8681: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
8682: || fnd_global.local_chr (10)
8683: || 'Old Cust Product : '

Line 8682: || fnd_global.local_chr (10)

8678: launch_workflow ( 'INSTALL BASE ACTIVITY : REPLACE '
8679: || fnd_global.local_chr (10)
8680: || 'Contract Number : '
8681: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
8682: || fnd_global.local_chr (10)
8683: || 'Old Cust Product : '
8684: || p_kdtl_tbl (l_ctr).old_cp_id
8685: || fnd_global.local_chr (10)
8686: || 'Replaced Cust Product : '

Line 8685: || fnd_global.local_chr (10)

8681: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
8682: || fnd_global.local_chr (10)
8683: || 'Old Cust Product : '
8684: || p_kdtl_tbl (l_ctr).old_cp_id
8685: || fnd_global.local_chr (10)
8686: || 'Replaced Cust Product : '
8687: || p_kdtl_tbl (l_ctr).new_cp_id
8688: );
8689: --END IF;

Line 9412: || fnd_global.local_chr (10)

9408:
9409: CLOSE l_serv_csr;
9410:
9411: launch_workflow ( 'INSTALL BASE ACTIVITY : RETURN '
9412: || fnd_global.local_chr (10)
9413: || 'Contract Number : '
9414: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
9415: || fnd_global.local_chr (10)
9416: || 'Service Terminated : '

Line 9415: || fnd_global.local_chr (10)

9411: launch_workflow ( 'INSTALL BASE ACTIVITY : RETURN '
9412: || fnd_global.local_chr (10)
9413: || 'Contract Number : '
9414: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
9415: || fnd_global.local_chr (10)
9416: || 'Service Terminated : '
9417: || l_service_name
9418: );
9419: EXIT WHEN l_ctr = p_kdtl_tbl.LAST;

Line 11477: || fnd_global.local_chr (10)

11473: END IF;
11474:
11475: launch_workflow
11476: ( 'INSTALL BASE ACTIVITY : TRANSFER TERMINATE SUBLINE '
11477: || fnd_global.local_chr (10)
11478: || 'Contract Number : '
11479: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
11480: || fnd_global.local_chr (10)
11481: || 'Service Terminated : '

Line 11480: || fnd_global.local_chr (10)

11476: ( 'INSTALL BASE ACTIVITY : TRANSFER TERMINATE SUBLINE '
11477: || fnd_global.local_chr (10)
11478: || 'Contract Number : '
11479: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
11480: || fnd_global.local_chr (10)
11481: || 'Service Terminated : '
11482: || l_service_name
11483: );
11484: ELSIF l_ste_code = 'ENTERED'

Line 12213: || fnd_global.local_chr (10)

12209: p_kdtl_tbl (l_ctr).hdr_sts;
12210: l_ptr := l_ptr + 1;
12211: launch_workflow
12212: ( 'INSTALL BASE ACTIVITY : TRANSFER TERMINATE SUBLINE '
12213: || fnd_global.local_chr (10)
12214: || 'Contract Number : '
12215: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
12216: || fnd_global.local_chr (10)
12217: || 'Service Terminated : '

Line 12216: || fnd_global.local_chr (10)

12212: ( 'INSTALL BASE ACTIVITY : TRANSFER TERMINATE SUBLINE '
12213: || fnd_global.local_chr (10)
12214: || 'Contract Number : '
12215: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
12216: || fnd_global.local_chr (10)
12217: || 'Service Terminated : '
12218: || l_service_name
12219: );
12220:

Line 12833: || fnd_global.local_chr (10)

12829: END IF;
12830:
12831: launch_workflow
12832: ( 'INSTALL BASE ACTIVITY : Transfer '
12833: || fnd_global.local_chr (10)
12834: || 'Contract Number : '
12835: || get_contract_number
12836: (l_merge_chr_id)
12837: || fnd_global.local_chr (10)

Line 12837: || fnd_global.local_chr (10)

12833: || fnd_global.local_chr (10)
12834: || 'Contract Number : '
12835: || get_contract_number
12836: (l_merge_chr_id)
12837: || fnd_global.local_chr (10)
12838: || 'Covered Product line merged into Contract : '
12839: || p_kdtl_tbl (l_ctr).old_cp_id
12840: );
12841: l_contract_merge := 'T';

Line 13375: || fnd_global.local_chr (10)

13371: END IF;
13372:
13373: launch_workflow
13374: ( 'INSTALL BASE ACTIVITY : TRANSFER '
13375: || fnd_global.local_chr (10)
13376: || 'Contract Number : '
13377: || get_contract_number (l_merge_chr_id)
13378: || fnd_global.local_chr (10)
13379: || 'Service line merged in to COntract : '

Line 13378: || fnd_global.local_chr (10)

13374: ( 'INSTALL BASE ACTIVITY : TRANSFER '
13375: || fnd_global.local_chr (10)
13376: || 'Contract Number : '
13377: || get_contract_number (l_merge_chr_id)
13378: || fnd_global.local_chr (10)
13379: || 'Service line merged in to COntract : '
13380: || l_service_name
13381: );
13382: l_contract_merge := 'T';

Line 13921: || fnd_global.local_chr (10)

13917: END IF;
13918:
13919: launch_workflow
13920: ( 'INSTALL BASE ACTIVITY : TRANSFER '
13921: || fnd_global.local_chr (10)
13922: || 'Contract Number : '
13923: || get_contract_number (l_chr_id)
13924: || fnd_global.local_chr (10)
13925: || 'New Contract Created : '

Line 13924: || fnd_global.local_chr (10)

13920: ( 'INSTALL BASE ACTIVITY : TRANSFER '
13921: || fnd_global.local_chr (10)
13922: || 'Contract Number : '
13923: || get_contract_number (l_chr_id)
13924: || fnd_global.local_chr (10)
13925: || 'New Contract Created : '
13926: || l_service_name
13927: );
13928: END IF;

Line 14664: || fnd_global.local_chr (10)

14660:
14661: CLOSE l_serv_csr;
14662:
14663: launch_workflow ( 'INSTALL BASE ACTIVITY : TERMINATE '
14664: || fnd_global.local_chr (10)
14665: || 'Contract Number : '
14666: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
14667: || fnd_global.local_chr (10)
14668: || 'Customer product end dated : '

Line 14667: || fnd_global.local_chr (10)

14663: launch_workflow ( 'INSTALL BASE ACTIVITY : TERMINATE '
14664: || fnd_global.local_chr (10)
14665: || 'Contract Number : '
14666: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
14667: || fnd_global.local_chr (10)
14668: || 'Customer product end dated : '
14669: || l_service_name
14670: );
14671: /* get_sts_code (NULL,

Line 15741: || fnd_global.local_chr (10)

15737: END IF;
15738:
15739: launch_workflow
15740: ( 'INSTALL BASE ACTIVITY : INSTALLTION DATE CHANGE '
15741: || fnd_global.local_chr (10)
15742: || 'Contract Number : '
15743: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
15744: || fnd_global.local_chr (10)
15745: || 'Inatallation date changed to : '

Line 15744: || fnd_global.local_chr (10)

15740: ( 'INSTALL BASE ACTIVITY : INSTALLTION DATE CHANGE '
15741: || fnd_global.local_chr (10)
15742: || 'Contract Number : '
15743: || get_contract_number (p_kdtl_tbl (l_ctr).hdr_id)
15744: || fnd_global.local_chr (10)
15745: || 'Inatallation date changed to : '
15746: || trunc(p_kdtl_tbl (l_ctr).installation_date)
15747: );
15748: EXIT WHEN l_ctr = p_kdtl_tbl.LAST;