DBA Data[Home] [Help]

APPS.CSFW_DEBRIEF_PUB dependencies on FND_PROFILE

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

172: open c_dbf_line_id;
173: fetch c_dbf_line_id into l_dbf_line_id;
174: close c_dbf_line_id;
175:
176: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
177:
178:
179: -------------------------------------------------------------------------------------------------
180: -------

Line 185: FND_PROFILE.GET ( 'CSFWDATEFORMAT' , l_dt_format);

181: ------- check for the Service date, which should not be less than SR date and more than Sysdate
182: -------
183: -------------------------------------------------------------------------------------------------
184: -- first get the date format
185: FND_PROFILE.GET ( 'CSFWDATEFORMAT' , l_dt_format);
186: -- Now get the SR Date in date format
187: open c_creation_date(p_incident_id);
188: fetch c_creation_date into l_sr_date;
189: close c_creation_date;

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

382: close c_dbf_lineId;
383:
384: l_user := FND_GLOBAL.user_id ;
385:
386: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
387:
388: open c_uom_code (l_organization_id, p_inventory_item_id);
389: fetch c_uom_code into l_UOM_code;
390: close c_uom_code;

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

517: close c_DEBRIEF_HEADER_ID;
518:
519: l_user := FND_GLOBAL.user_id ;
520:
521: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
522:
523: open c_uom_code (l_organization_id, p_inventory_item_id);
524: fetch c_uom_code into l_UOM_code;
525: close c_uom_code;

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

671:
672: --select FND_GLOBAL.user_id into l_user from dual;
673: l_user :=FND_GLOBAL.user_id ;
674:
675: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
676:
677:
678:
679: -------------------------------------------------------------------------------------------------

Line 685: FND_PROFILE.GET ( 'CSFWDATEFORMAT' , l_dt_format);

681: ------- check for the Service date, which should not be less than SR date and more than Sysdate
682: -------
683: -------------------------------------------------------------------------------------------------
684: -- first get the date format
685: FND_PROFILE.GET ( 'CSFWDATEFORMAT' , l_dt_format);
686: -- Now get the SR Date in date format
687: open c_creation_date(p_incident_id);
688: fetch c_creation_date into l_sr_date;
689: close c_creation_date;

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

1046:
1047: BEGIN
1048:
1049: --dbms_output.put_line('BEGINING....');
1050: l_client_tz_id := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
1051: l_server_tz_id := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
1052:
1053: -- first lets get the nulls out
1054: if p_taskid = '$$#@' then

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

1047: BEGIN
1048:
1049: --dbms_output.put_line('BEGINING....');
1050: l_client_tz_id := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
1051: l_server_tz_id := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
1052:
1053: -- first lets get the nulls out
1054: if p_taskid = '$$#@' then
1055: l_taskid := null;

Line 1295: FND_PROFILE.GET ( 'CSFWDATEFORMAT' , l_dt_format);

1291: ------- check for the Service date, which should not be less than SR date and more than Sysdate
1292: -------
1293: -------------------------------------------------------------------------------------------------
1294: -- first get the date format
1295: FND_PROFILE.GET ( 'CSFWDATEFORMAT' , l_dt_format);
1296: -- Now get the SR Date in date format
1297: open c_creation_date(l_incidentid);
1298: fetch c_creation_date into l_sr_date;
1299: close c_creation_date;

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

1922: l_party_id := r_party.customer_id;
1923: l_party_account_id := r_party.customer_account_id;
1924:
1925:
1926: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_inv_organization_id);
1927:
1928: if (r_ib_rec.line_order_category_code = 'RETURN' ) then
1929: l_in_out_flag:='IN';
1930: open c_internal_party_id;