DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on FND_PROFILE

Line 38: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

34: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_REQCHANGEREQUESTNOTIF_PVT';
35: G_FILE_NAME CONSTANT VARCHAR2(30) := 'POXVRCNB.pls';
36:
37: -- Read the profile option that enables/disables the debug log
38: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
39: g_module_prefix CONSTANT VARCHAR2(50) := 'po.plsql.' || g_pkg_name || '.';
40:
41: Procedure get_additional_details(p_req_header_id in number,
42: p_document out NOCOPY varchar2);

Line 296: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

292:
293:
294: NL VARCHAR2(1) := fnd_global.newline;
295:
296: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
297:
298:
299: BEGIN
300:

Line 471: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

467:
468:
469: NL VARCHAR2(1) := fnd_global.newline;
470:
471: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
472:
473: cursor l_get_wf_keys_csr is
474: select wf_item_type, wf_item_key
475: from po_change_requests

Line 652: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

648: l_old_line_amount number;
649: l_request_status po_change_requests.request_status%type;
650:
651: display_txn_curr VARCHAR2(30);
652: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
653:
654:
655: CURSOR line_csr(v_document_id NUMBER) IS
656: SELECT rql.requisition_line_id,

Line 735: display_txn_curr := FND_PROFILE.value('POR_DEFAULT_DISP_TRANS_CURRENCY');

731: aname => 'ORG_ID');
732:
733: SetDocMgrContext(l_item_type, l_item_key);
734:
735: display_txn_curr := FND_PROFILE.value('POR_DEFAULT_DISP_TRANS_CURRENCY');
736:
737:
738: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
739:

Line 777: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));

773: l_document := l_document || NL || NL || ''|| NL || NL || '

';
774:
775: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS'));
776:
777: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
778:
779: select count(1)
780: into l_num_lines
781: from po_requisition_lines

Line 1163: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

1159: l_old_line_amount number;
1160: l_request_status po_change_requests.request_status%type;
1161:
1162: display_txn_curr VARCHAR2(30);
1163: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1164:
1165:
1166: CURSOR line_csr(v_document_id NUMBER) IS
1167: SELECT rql.requisition_line_id,

Line 1247: display_txn_curr := FND_PROFILE.value('POR_DEFAULT_DISP_TRANS_CURRENCY');

1243: aname => 'ORG_ID');
1244:
1245: SetDocMgrContext(l_item_type, l_item_key);
1246:
1247: display_txn_curr := FND_PROFILE.value('POR_DEFAULT_DISP_TRANS_CURRENCY');
1248:
1249: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1250:
1251: l_currency_code := PO_CORE_S2.get_base_currency;

Line 1288: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));

1284: l_document := l_document || NL || NL || ''|| NL || NL || '

';
1285:
1286: l_document := l_document || PrintHeading(fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS'));
1287:
1288: l_max_lines := to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
1289:
1290: select count(1)
1291: into l_num_lines
1292: from po_requisition_lines

Line 1938: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

1934: l_document VARCHAR2(32000) := '';
1935:
1936: NL VARCHAR2(1) := fnd_global.newline;
1937:
1938: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1939:
1940: l_note po_action_history.note%TYPE;
1941: l_old_req_amount VARCHAR2(40);
1942: l_old_tax_amount VARCHAR2(40);

Line 2123: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

2119:
2120: l_document varchar2(1000) := '';
2121:
2122: NL VARCHAR2(1) := fnd_global.newline;
2123: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2124:
2125: begin
2126:
2127: l_document := '';

Line 2482: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

2478: l_display_type in varchar2,
2479: l_document out NOCOPY varchar2) is
2480:
2481: l_item MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
2482: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2483:
2484: begin
2485:
2486: if (l_display_type = 'text/html' ) then

Line 3263: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

3259: l_pb_rate_type po_headers_all.rate_type%type;
3260: l_pb_rate_date date;
3261: l_pb_rate number;
3262:
3263: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
3264: NL VARCHAR2(1) := fnd_global.newline;
3265:
3266: l_has_temp_labor boolean :=false;
3267: l_num_temp_labors number :=0;

Line 3284: l_retropricing := fnd_profile.value('PO_ALLOW_RETROPRICING_OF_PO');

3280: l_call_price_break boolean := true;
3281:
3282:
3283: BEGIN
3284: l_retropricing := fnd_profile.value('PO_ALLOW_RETROPRICING_OF_PO');
3285:
3286: l_grp_id := to_number(document_id);
3287: open l_get_document_id_csr(l_grp_id);
3288: fetch l_get_document_id_csr into l_header_id, l_release_id;

Line 3992: l_retropricing := fnd_profile.value('PO_ALLOW_RETROPRICING_OF_PO');

3988: return null;
3989:
3990: end if;
3991:
3992: l_retropricing := fnd_profile.value('PO_ALLOW_RETROPRICING_OF_PO');
3993:
3994: l_progress:='001';
3995: if g_fnd_debug = 'Y' then
3996: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN