DBA Data[Home] [Help]

APPS.CSFW_DEBRIEF_PUB dependencies on FND_PROFILE

Line 312: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);

308: open c_dbf_line_id;
309: fetch c_dbf_line_id into l_dbf_line_id;
310: close c_dbf_line_id;
311:
312: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
313:
314:
315: -------------------------------------------------------------------------------------------------
316: -------

Line 322: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK', l_dt_format);

318: -------
319: -------------------------------------------------------------------------------------------------
320: -- first get the date format
321: -- Bug 2862796. Using ICX: Date Format Mask in place of CSFW: Date Format.
322: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK', l_dt_format);
323:
324: -- Now get the SR Date in date format
325: open c_creation_date(p_incident_id);
326: fetch c_creation_date into l_sr_date;

Line 681: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);

677: close c_dbf_lineId;
678:
679: l_user := FND_GLOBAL.user_id ;
680:
681: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
682:
683: open c_uom_code (l_organization_id, p_inventory_item_id);
684: fetch c_uom_code into l_UOM_code;
685: close c_uom_code;

Line 970: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);

966: close c_DEBRIEF_HEADER_ID;
967:
968: l_user := FND_GLOBAL.user_id ;
969:
970: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
971:
972: open c_uom_code (l_organization_id, p_inventory_item_id);
973: fetch c_uom_code into l_UOM_code;
974: close c_uom_code;

Line 1282: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);

1278:
1279: --select FND_GLOBAL.user_id into l_user from dual;
1280: l_user :=FND_GLOBAL.user_id ;
1281:
1282: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
1283:
1284:
1285:
1286: -------------------------------------------------------------------------------------------------

Line 1293: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK', l_dt_format);

1289: -------
1290: -------------------------------------------------------------------------------------------------
1291: -- first get the date format
1292: -- Bug 2862796. Using ICX: Date Format Mask in place of CSFW: Date Format.
1293: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK', l_dt_format);
1294: -- Now get the SR Date in date format
1295: open c_creation_date(p_incident_id);
1296: fetch c_creation_date into l_sr_date;
1297: close c_creation_date;

Line 1734: l_client_tz_id := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));

1730:
1731: BEGIN
1732:
1733: --dbms_output.put_line('BEGINING....');
1734: l_client_tz_id := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
1735: l_server_tz_id := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
1736:
1737: -- first lets get the nulls out
1738: if p_taskid = '$$#@' then

Line 1735: l_server_tz_id := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

1731: BEGIN
1732:
1733: --dbms_output.put_line('BEGINING....');
1734: l_client_tz_id := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
1735: l_server_tz_id := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
1736:
1737: -- first lets get the nulls out
1738: if p_taskid = '$$#@' then
1739: l_taskid := null;

Line 2110: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK', l_dt_format);

2106: -------
2107: -------------------------------------------------------------------------------------------------
2108: -- first get the date format
2109: -- Bug 2862796. Using ICX: Date Format Mask in place of CSFW: Date Format.
2110: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK', l_dt_format);
2111:
2112: -- Now get the SR Date in date format
2113: open c_creation_date(l_incidentid);
2114: fetch c_creation_date into l_sr_date;

Line 2775: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_inv_organization_id);

2771: l_party_id := r_party.customer_id;
2772: l_party_account_id := r_party.customer_account_id;
2773:
2774:
2775: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_inv_organization_id);
2776:
2777: if (r_ib_rec.line_order_category_code = 'RETURN' ) then
2778: l_in_out_flag:='IN';
2779: open c_internal_party_id;