APPS.IEM_EMAIL_PROC_PVT dependencies on CSI_ITEM_INSTANCES

Line 7441: from csi_item_instances

7437: ELSIF p_instance_number is not null then
7438: BEGIN
7439: select distinct owner_party_id
7440: into x_customer_id
7441: from csi_item_instances
7442: where instance_number = p_instance_number;
7443: EXCEPTION
7444: when TOO_MANY_ROWS then
7445: x_customer_id := null;

Line 7465: from csi_item_instances

7461: ELSIF p_instance_serial_number is not null then
7462: BEGIN
7463: select distinct owner_party_id
7464: into x_customer_id
7465: from csi_item_instances
7466: where serial_number = p_instance_serial_number;
7467: EXCEPTION
7468: when TOO_MANY_ROWS then
7469: x_customer_id := null;

Line 7961: from csi_item_instances

7957: IF (p_cust_account_id IS NOT NULL) THEN
7958: BEGIN
7959: select instance_id,inventory_item_id, inv_master_organization_id
7960: into x_customer_product_id, x_inventory_item_id, x_inventory_org_id
7961: from csi_item_instances
7962: where instance_number = p_instance_number
7963: and owner_party_account_id = p_cust_account_id
7964: and owner_party_id = g_customer_id;
7965: EXCEPTION

Line 7986: from csi_item_instances

7982: ELSE
7983: BEGIN
7984: select instance_id,inventory_item_id, inv_master_organization_id
7985: into x_customer_product_id, x_inventory_item_id, x_inventory_org_id
7986: from csi_item_instances
7987: where instance_number = p_instance_number
7988: and owner_party_id = g_customer_id;
7989: EXCEPTION
7990: when TOO_MANY_ROWS then

Line 8012: from csi_item_instances

8008: IF (p_cust_account_id IS NOT NULL) THEN
8009: BEGIN
8010: select instance_id,inventory_item_id, inv_master_organization_id
8011: into x_customer_product_id, x_inventory_item_id, x_inventory_org_id
8012: from csi_item_instances
8013: where instance_number = p_instance_number
8014: and owner_party_account_id = p_cust_account_id;
8015: EXCEPTION
8016: when TOO_MANY_ROWS then

Line 8036: from csi_item_instances

8032: ELSE
8033: BEGIN
8034: select instance_id,inventory_item_id, inv_master_organization_id
8035: into x_customer_product_id, x_inventory_item_id, x_inventory_org_id
8036: from csi_item_instances
8037: where instance_number = p_instance_number;
8038: EXCEPTION
8039: when TOO_MANY_ROWS then
8040: x_customer_product_id := null;

Line 8110: from csi_item_instances

8106: iem_logger(l_logmessage);
8107: --dbms_output.put_line(l_logmessage);
8108: select instance_id,inventory_item_id,inv_master_organization_id
8109: into x_customer_product_id, x_inventory_item_id, x_inventory_org_id
8110: from csi_item_instances
8111: where serial_number = p_instance_serial_number
8112: and owner_party_account_id = p_cust_account_id
8113: and owner_party_id = g_customer_id;
8114:

Line 8139: from csi_item_instances

8135: ELSE
8136: BEGIN
8137: select instance_id,inventory_item_id,inv_master_organization_id
8138: into x_customer_product_id, x_inventory_item_id, x_inventory_org_id
8139: from csi_item_instances
8140: where serial_number = p_instance_serial_number
8141: and owner_party_id = g_customer_id;
8142: l_logmessage:='account_id is null ';
8143: iem_logger(l_logmessage);

Line 8173: from csi_item_instances

8169: IF (p_cust_account_id IS NOT NULL) THEN
8170: BEGIN
8171: select instance_id,inventory_item_id, inv_master_organization_id
8172: into x_customer_product_id, x_inventory_item_id, x_inventory_org_id
8173: from csi_item_instances
8174: where serial_number = p_instance_serial_number
8175: and owner_party_account_id = p_cust_account_id;
8176: l_logmessage:='account_id is not null in the else section meaning g_customer_id is null ';
8177: iem_logger(l_logmessage);

Line 8204: from csi_item_instances

8200: ELSE
8201: BEGIN
8202: select instance_id,inventory_item_id, inv_master_organization_id
8203: into x_customer_product_id, x_inventory_item_id, x_inventory_org_id
8204: from csi_item_instances
8205: where serial_number = p_instance_serial_number;
8206:
8207: l_logmessage:='account_id is null ';
8208: iem_logger(l_logmessage);

Line 8982: from csi_item_instances

8978: --we will just do a simple validation for ext_Ref_item and if it exists
8979: --then we will just pass it to the SR API and the let the SR api handle
8980: --additional validation.
8981: select count(external_reference) into l_ext_ref_count
8982: from csi_item_instances
8983: where upper(external_reference) = upper(p_ext_ref);
8984: --where instance_id = p_customer_product_id
8985: l_logmessage:='external reference count for '|| p_ext_Ref||' is '||l_ext_ref_count;
8986: iem_logger(l_logmessage);