DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on FND_PROFILE

Line 106: l_negative_yn := NVL(FND_PROFILE.VALUE('OKS_NEGATIVE_BILLING_YN'),'NO');

102:
103: BEGIN
104:
105: X_return_status := 'S';
106: l_negative_yn := NVL(FND_PROFILE.VALUE('OKS_NEGATIVE_BILLING_YN'),'NO');
107: FOR l_ptr in 1..p_cov_tbl.count
108: LOOP
109: OPEN l_bill_qty_csr(p_cov_tbl(l_ptr).id);
110: FETCH l_bill_qty_csr into l_bill_qty_rec;

Line 353: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN

349: ELSE
350: IF (p_summary_yn = 'Y') THEN
351: l_processed_lines_tbl(l_pr_tbl_idx).Summary_bill_YN := 'Y';
352: ELSE
353: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN
354: l_processed_lines_tbl(l_pr_tbl_idx).Summary_bill_YN := 'Y';
355: ELSE
356: l_processed_lines_tbl(l_pr_tbl_idx).Summary_bill_YN := 'N';
357: END IF;

Line 412: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN

408: ELSE
409: IF (p_summary_yn = 'Y') THEN
410: l_processed_sub_lines_tbl(l_prs_tbl_idx).Summary_bill_YN := 'Y';
411: ELSE
412: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN
413: l_processed_sub_lines_tbl(l_prs_tbl_idx).Summary_bill_YN := 'Y';
414: ELSE
415: l_processed_sub_lines_tbl(l_prs_tbl_idx).Summary_bill_YN := 'N';
416: END IF;

Line 1561: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN

1557:
1558: IF (p_summary_yn = 'Y') THEN
1559: l_summary_yn := 'Y';
1560: ELSE
1561: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN
1562: l_summary_yn := 'Y';
1563: ELSE
1564: l_summary_yn := 'N';
1565: END IF;

Line 2469: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');

2465: X_return_status := 'S';
2466:
2467: --mchoudha Fix for bug#4198616
2468: --initializing the variables in case of parallel workers
2469: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
2470: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => OKS: Billing Report And Log is set to '||l_yes_no);
2471:
2472: If l_write_log then
2473: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill processing starts ');

Line 2985: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');

2981: BEGIN
2982:
2983: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Starts');
2984:
2985: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
2986:
2987: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main => OKS: Billing Report And Log is set to '||l_yes_no);
2988:
2989: If l_yes_no = 'YES' then

Line 3000: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN

2996:
2997: l_org_id := p_org_id;
2998:
2999: --mchoudha fixed bug#4729936
3000: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN
3001: -- l_org_id := fnd_profile.value('ORG_ID');
3002: If l_write_log then
3003: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => parameter Org ID is '||l_org_id);
3004: End If;

Line 3001: -- l_org_id := fnd_profile.value('ORG_ID');

2997: l_org_id := p_org_id;
2998:
2999: --mchoudha fixed bug#4729936
3000: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN
3001: -- l_org_id := fnd_profile.value('ORG_ID');
3002: If l_write_log then
3003: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => parameter Org ID is '||l_org_id);
3004: End If;
3005: -- END IF;

Line 3326: (nvl(FND_PROFILE.VALUE('OKS_PARALLEL_WORKER'),'NO') = 'YES') THEN

3322:
3323:
3324: IF (p_contract_hdr_id is null) AND -- not a specific contract
3325: (FND_CONC_GLOBAL.request_data is null) AND -- not a restart of parent
3326: (nvl(FND_PROFILE.VALUE('OKS_PARALLEL_WORKER'),'NO') = 'YES') THEN
3327:
3328: -- l_line_no represent total records to be processed here
3329: If l_write_log then
3330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Profile option OKS: Parallel Worker is set to YES');

Line 3385: (nvl(FND_PROFILE.VALUE('OKS_PARALLEL_WORKER'),'NO') = 'YES')) THEN

3381: return; -- parent exits and waits for children to finish before restart
3382: END IF; -- l_agg_rec.total
3383:
3384: ELSIF ((FND_CONC_GLOBAL.request_data is not null ) AND
3385: (nvl(FND_PROFILE.VALUE('OKS_PARALLEL_WORKER'),'NO') = 'YES')) THEN
3386: -- restart detected (sub-requests finished)...cleanup and exit.
3387: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Commiting here');
3388: COMMIT;
3389:

Line 3576: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN

3572:
3573: l_org_id := p_org_id;
3574:
3575: --mchoudha fixed bug#4729936
3576: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN
3577: -- l_org_id := fnd_profile.value('ORG_ID');
3578: --END IF;
3579:
3580: --Bug # 4928184 19-JAN-2006 maanand

Line 3577: -- l_org_id := fnd_profile.value('ORG_ID');

3573: l_org_id := p_org_id;
3574:
3575: --mchoudha fixed bug#4729936
3576: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN
3577: -- l_org_id := fnd_profile.value('ORG_ID');
3578: --END IF;
3579:
3580: --Bug # 4928184 19-JAN-2006 maanand
3581: