APPS.CSI_ML_UPDATE_PVT dependencies on DUAL

Line 733: FROM DUAL;

729: x_instance_tbl(inst_idx).instance_usage_code,
730: x_instance_tbl(inst_idx).check_for_instance_expiry,
731: x_instance_tbl(inst_idx).instance_description,
732: x_instance_tbl(inst_idx).operational_status_code
733: FROM DUAL;
734:
735: x_instance_tbl(inst_idx).INTERFACE_ID := inst_intf_rec.inst_interface_id;
736:
737: ---Populate Pricing attribites

Line 1680: FROM DUAL;

1676: x_price_tbl(price_idx).attribute13,
1677: x_price_tbl(price_idx).attribute14,
1678: x_price_tbl(price_idx).attribute15,
1679: x_price_tbl(price_idx).object_version_number
1680: FROM DUAL;
1681: END IF;
1682:
1683:
1684: ---Populate Org Assignments

Line 1760: FROM DUAL;

1756: x_org_assign_tbl(org_idx).attribute13,
1757: x_org_assign_tbl(org_idx).attribute14,
1758: x_org_assign_tbl(org_idx).attribute15,
1759: x_org_assign_tbl(org_idx).object_version_number
1760: FROM DUAL;
1761: END IF; --Org Assignments
1762:
1763:
1764: ----Populate Party

Line 1948: FROM DUAL;

1944: x_party_tbl (prty_idx).attribute13,
1945: x_party_tbl (prty_idx).attribute14,
1946: x_party_tbl (prty_idx).attribute15,
1947: x_party_tbl (prty_idx).object_version_number
1948: FROM DUAL;
1949:
1950: x_party_tbl (prty_idx).parent_tbl_index:=inst_idx;
1951: IF (x_party_tbl(prty_idx).contact_flag = 'Y'
1952: AND x_party_tbl(prty_idx).contact_ip_id IS NULL)

Line 2139: FROM DUAL;

2135: x_account_tbl (ptyacc_idx).attribute14,
2136: x_account_tbl (ptyacc_idx).attribute15,
2137: x_account_tbl (ptyacc_idx).call_contracts,
2138: x_account_tbl (ptyacc_idx).vld_organization_id
2139: FROM DUAL;
2140: END IF; ---party_account1
2141:
2142: ---Populate Party Account2
2143: IF party_intf_rec.party_account2_id IS NOT NULL

Line 2319: FROM DUAL;

2315: x_account_tbl (ptyacc_idx).attribute14,
2316: x_account_tbl (ptyacc_idx).attribute15,
2317: x_account_tbl (ptyacc_idx).call_contracts,
2318: x_account_tbl (ptyacc_idx).vld_organization_id
2319: FROM DUAL;
2320: END IF; ---party_account2
2321:
2322: ---Populate Party Account3
2323: IF party_intf_rec.party_account3_id IS NOT NULL

Line 2499: FROM DUAL;

2495: x_account_tbl (ptyacc_idx).attribute14,
2496: x_account_tbl (ptyacc_idx).attribute15,
2497: x_account_tbl (ptyacc_idx).call_contracts,
2498: x_account_tbl (ptyacc_idx).vld_organization_id
2499: FROM DUAL;
2500: END IF; ---party_account3
2501:
2502: IF party_intf_rec.contact_party_id IS NOT NULL AND
2503: party_intf_rec.contact_party_id <> fnd_api.g_miss_num

Line 2611: FROM DUAL;

2607: x_ext_attrib_value_tbl (extatt_idx).attribute13,
2608: x_ext_attrib_value_tbl (extatt_idx).attribute14,
2609: x_ext_attrib_value_tbl (extatt_idx).attribute15,
2610: x_ext_attrib_value_tbl (extatt_idx).object_version_number
2611: FROM DUAL;
2612: END LOOP; ---ext_attrib_intf_cur
2613:
2614: --bnarayan added for R12
2615: -- Populate asset records