DBA Data[Home] [Help]

APPS.CSD_RETURNS_UTIL dependencies on FND_PROFILE

Line 124: p_severity_id => fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY'),

120: p_customer_product_id => p_instance_ids(i),
121: p_request_date => TRUNC(SYSDATE),
122: p_validate_flag => 'Y',
123: p_business_process_id => l_business_process,
124: p_severity_id => fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY'),
125: p_time_zone_id => TO_NUMBER(fnd_profile.value('SERVER_TIMEZONE_ID')),
126: p_calc_resptime_flag => 'Y',
127: x_ent_contracts => x_ent_contracts,
128: x_return_status => x_return_status,

Line 125: p_time_zone_id => TO_NUMBER(fnd_profile.value('SERVER_TIMEZONE_ID')),

121: p_request_date => TRUNC(SYSDATE),
122: p_validate_flag => 'Y',
123: p_business_process_id => l_business_process,
124: p_severity_id => fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY'),
125: p_time_zone_id => TO_NUMBER(fnd_profile.value('SERVER_TIMEZONE_ID')),
126: p_calc_resptime_flag => 'Y',
127: x_ent_contracts => x_ent_contracts,
128: x_return_status => x_return_status,
129: x_msg_count => x_msg_count,

Line 356: l_org_id NUMBER := fnd_profile.value('ORG_ID');

352: l_selling_price NUMBER;
353: l_contract_discount NUMBER;
354: l_pricing_attr_rec csd_process_util.pricing_attr_rec;
355: l_txn_billing_type_id NUMBER;
356: l_org_id NUMBER := fnd_profile.value('ORG_ID');
357: x_contract_pl_id NUMBER;
358: x_profile_pl_id NUMBER;
359:
360: BEGIN

Line 658: l_payer_context_rec.org_id := fnd_profile.value('ORG_ID');

654: -- check if the payee already exists. If not register the payee.
655: l_payer_context_rec.payment_function := 'CUSTOMER_PAYMENT';
656: l_payer_context_rec.party_id := p_party_id;
657: l_payer_context_rec.org_type := 'OPERATING_UNIT';
658: l_payer_context_rec.org_id := fnd_profile.value('ORG_ID');
659: l_payer_context_rec.cust_account_id := p_account_id;
660:
661: -- establish the save point.
662: SAVEPOINT process_credit_card;

Line 892: l_payee_context_rec.org_id := fnd_profile.value('ORG_ID');

888: l_amount_rec.currency_code := p_currency_code;
889:
890: -- step 2. prepare the payee type rec.
891: l_payee_context_rec.org_type := 'OPERATING_UNIT';
892: l_payee_context_rec.org_id := fnd_profile.value('ORG_ID');
893:
894: -- step 3. Prepare the authorization attributes rec type.
895: -- at this point I dont think we need to pass any specific values to this rec.
896: -- the default values are good as per IBY documentation.

Line 1362: l_crt_inst_party_relation VARCHAR2(30) := fnd_profile.value('CSD_DEF_INST_PTY_RELTN');

1358: retcode VARCHAR2(100);
1359: errbuff VARCHAR2(2000);
1360: l_attach_index NUMBER := 1;
1361: l_repair_line_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1362: l_crt_inst_party_relation VARCHAR2(30) := fnd_profile.value('CSD_DEF_INST_PTY_RELTN');
1363: l_relationship VARCHAR2(30);
1364: x_relationship_created VARCHAR2(1);
1365:
1366: TYPE item_attributes_rec IS RECORD

Line 1404: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');

1400: END IF;
1401: l_service_request_rec.customer_id := p_party_id;
1402: l_service_request_rec.account_id := p_account_id;
1403: l_service_request_rec.request_date := sysdate;
1404: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
1405: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
1406: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
1407: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
1408: l_service_request_rec.closed_date := null;

Line 1405: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');

1401: l_service_request_rec.customer_id := p_party_id;
1402: l_service_request_rec.account_id := p_account_id;
1403: l_service_request_rec.request_date := sysdate;
1404: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
1405: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
1406: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
1407: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
1408: l_service_request_rec.closed_date := null;
1409: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');

Line 1406: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');

1402: l_service_request_rec.account_id := p_account_id;
1403: l_service_request_rec.request_date := sysdate;
1404: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
1405: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
1406: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
1407: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
1408: l_service_request_rec.closed_date := null;
1409: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
1410: l_service_request_rec.owner_group_id := NULL;

Line 1407: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');

1403: l_service_request_rec.request_date := sysdate;
1404: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
1405: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
1406: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
1407: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
1408: l_service_request_rec.closed_date := null;
1409: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
1410: l_service_request_rec.owner_group_id := NULL;
1411: l_service_request_rec.publish_flag := '';

Line 1409: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');

1405: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
1406: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
1407: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
1408: l_service_request_rec.closed_date := null;
1409: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
1410: l_service_request_rec.owner_group_id := NULL;
1411: l_service_request_rec.publish_flag := '';
1412: l_service_request_rec.summary := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SUMMARY');
1413: l_service_request_rec.resource_type := FND_PROFILE.value('CS_SR_DEFAULT_OWNER_TYPE');

Line 1412: l_service_request_rec.summary := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SUMMARY');

1408: l_service_request_rec.closed_date := null;
1409: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
1410: l_service_request_rec.owner_group_id := NULL;
1411: l_service_request_rec.publish_flag := '';
1412: l_service_request_rec.summary := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SUMMARY');
1413: l_service_request_rec.resource_type := FND_PROFILE.value('CS_SR_DEFAULT_OWNER_TYPE');
1414: l_service_request_rec.bill_to_site_use_id := p_bill_to_addr_use_id;
1415: l_service_request_rec.ship_to_site_use_id := p_ship_to_addr_use_id;
1416: -- get the party type.

Line 1413: l_service_request_rec.resource_type := FND_PROFILE.value('CS_SR_DEFAULT_OWNER_TYPE');

1409: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
1410: l_service_request_rec.owner_group_id := NULL;
1411: l_service_request_rec.publish_flag := '';
1412: l_service_request_rec.summary := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SUMMARY');
1413: l_service_request_rec.resource_type := FND_PROFILE.value('CS_SR_DEFAULT_OWNER_TYPE');
1414: l_service_request_rec.bill_to_site_use_id := p_bill_to_addr_use_id;
1415: l_service_request_rec.ship_to_site_use_id := p_ship_to_addr_use_id;
1416: -- get the party type.
1417: SELECT party_type

Line 1589: AND organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');

1585: FROM mtl_system_items_b
1586: WHERE inventory_item_id IN
1587: (SELECT * FROM TABLE(CAST(p_item_ids AS JTF_NUMBER_TABLE))
1588: )
1589: AND organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
1590:
1591: -- bug#14094846, subhat.
1592: FOR i IN 1 ..l_item_ids_tbl.COUNT
1593: LOOP

Line 1838: l_repln_rec.approval_required_flag := NVL(fnd_profile.value('CSD_CUST_APPROVAL_REQD'),'N');

1834: l_repln_rec.repair_type_id := p_repair_type_ids(i);
1835: l_repln_rec.repair_group_id := null;
1836: l_repln_rec.inventory_item_id := p_item_ids(i);
1837: l_repln_rec.unit_of_measure := p_uom_codes(i);
1838: l_repln_rec.approval_required_flag := NVL(fnd_profile.value('CSD_CUST_APPROVAL_REQD'),'N');
1839: l_repln_rec.quantity := p_quantities(i);
1840: l_repln_rec.serial_number := p_serial_nums(i);
1841:
1842: -- get the autoprocess RMA flag.

Line 2093: l_estimate_lines_rec.organization_id := fnd_profile.value('CSD_DEF_REP_INV_ORG');

2089: l_estimate_lines_rec.coverage_txn_group_id := NULL;
2090: l_estimate_lines_rec.coverage_bill_rate_id := NULL;
2091: l_estimate_lines_rec.sub_inventory := NULL;
2092:
2093: l_estimate_lines_rec.organization_id := fnd_profile.value('CSD_DEF_REP_INV_ORG');
2094: l_estimate_lines_rec.invoice_to_org_id := NULL;
2095: l_estimate_lines_rec.ship_to_org_id := NULL;
2096: l_estimate_lines_rec.no_charge_flag := 'N';
2097: l_estimate_lines_rec.return_reason := NULL; --p_ret_reasons(i);