DBA Data[Home] [Help]

APPS.OZF_CLAIM_PUB dependencies on FND_PROFILE

Line 87: l_inv_org_id NUMBER := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');

83: AND uom_code = p_item_uom;
84:
85: l_item_uom VARCHAR2(30);
86:
87: l_inv_org_id NUMBER := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');
88:
89: BEGIN
90: -- Standard Start of API savepoint
91: SAVEPOINT CREATE_Claim_PUB;

Line 690: l_inv_org_id NUMBER := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');

686: AND c.inventory_item_id = p_inventory_item_id
687: AND uom_code = p_item_uom;
688:
689: l_item_uom VARCHAR2(30);
690: l_inv_org_id NUMBER := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');
691:
692: BEGIN
693: -- Standard Start of API savepoint
694: SAVEPOINT SAVE_UPDATE_CLAIM_PUB;

Line 1484: l_inv_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');

1480:
1481: IF l_claim_line_tbl(i).item_id IS NOT NULL THEN
1482: IF l_pvt_claim_line_tbl(i).item_type = 'PRODUCT' THEN
1483: l_item_id := NULL;
1484: l_inv_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');
1485: OPEN c_inventory_item_id( l_claim_line_tbl(i).item_id,l_inv_org_id);
1486: FETCH c_inventory_item_id INTO l_item_id,l_pvt_claim_line_tbl(i).item_description;
1487: CLOSE c_inventory_item_id;
1488: