APPS.CSP_PARTS_ORDER dependencies on FND_PROFILE

Line 502: fnd_profile.get('RESP_ID',orig_resp_id);

498: -- initialize return status
499: x_return_status := FND_API.G_RET_STS_SUCCESS;
500:
501: l_user_id := nvl(fnd_global.user_id, 0) ;
502: fnd_profile.get('RESP_ID',orig_resp_id);
503: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
504:
505: BEGIN
506: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))

Line 503: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);

499: x_return_status := FND_API.G_RET_STS_SUCCESS;
500:
501: l_user_id := nvl(fnd_global.user_id, 0) ;
502: fnd_profile.get('RESP_ID',orig_resp_id);
503: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
504:
505: BEGIN
506: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
507: INTO l_org_id

Line 1279: fnd_profile.get('RESP_ID',orig_resp_id);

1275: -- initialize return status
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277:
1278: l_user_id := nvl(fnd_global.user_id, 0) ;
1279: fnd_profile.get('RESP_ID',orig_resp_id);
1280: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
1281:
1282: l_header_rec := px_header_rec;
1283: l_line_tbl := px_line_table;

Line 1280: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);

1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277:
1278: l_user_id := nvl(fnd_global.user_id, 0) ;
1279: fnd_profile.get('RESP_ID',orig_resp_id);
1280: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
1281:
1282: l_header_rec := px_header_rec;
1283: l_line_tbl := px_line_table;
1284:

Line 2582: /* fnd_profile.get('ORG_ID',new_org_id); --Operating Unit for the new context.

2578: IF new_resp_id is not null and
2579: new_resp_appl_id is not null THEN
2580: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
2581: mo_global.set_org_context(l_source_operating_unit,null,'CSF');
2582: /* fnd_profile.get('ORG_ID',new_org_id); --Operating Unit for the new context.
2583: IF l_source_operating_unit <> new_org_id THEN
2584: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_NOT_MATCH'); --to be seeded.
2585: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
2586: FND_MSG_PUB.Add;

Line 2991: FND_PROFILE.GET('CSP_PO_LINE_TYPE', l_line_Type_id);

2987: po_message_s.sql_error('check_unique','010',sqlcode);
2988: raise;
2989: END;
2990:
2991: FND_PROFILE.GET('CSP_PO_LINE_TYPE', l_line_Type_id);
2992:
2993: FOR I IN 1..l_line_tbl.COUNT LOOP
2994:
2995: -- get requisition_line_id