APPS.CSM_SERVICE_REQUESTS_PKG dependencies on CS_INCIDENTS

Line 49: CURSOR c_party ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE )

45: WHERE inventory_item_id = p_inventory_item_id
46: AND organization_id = p_organization_id;
47:
48: /* Cursor to select party Type */
49: CURSOR c_party ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE )
50: IS
51: SELECT PARTY_TYPE
52: FROM HZ_PARTIES
53: WHERE party_id = b_customer_id;

Line 77: CURSOR c_customer_account ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)

73: FROM CSI_ITEM_INSTANCES
74: WHERE SERIAL_NUMBER = c_serial_number;
75:
76: /* Cursor to get the customer account id */
77: CURSOR c_customer_account ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)
78: IS
79: SELECT custa.cust_account_id
80: FROM hz_cust_accounts custa
81: WHERE custa.status = 'A'

Line 89: FROM CS_INCIDENTS

85: CURSOR C_OVN( B_INCIDENT_ID NUMBER)
86: IS
87: SELECT INCIDENT_ID
88: , OBJECT_VERSION_NUMBER
89: FROM CS_INCIDENTS
90: WHERE INCIDENT_ID = B_INCIDENT_ID;
91: R_OVN C_OVN%ROWTYPE;
92:
93: /***

Line 105: CURSOR c_bill_to_site_id( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)

101: ) IS
102:
103: /* Bug 3917132
104: Cursor to get the Bill to Address */
105: CURSOR c_bill_to_site_id( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)
106: IS
107: SELECT use.party_site_use_id
108: FROM hz_party_sites site, hz_party_site_uses use
109: WHERE site.party_site_id = use.party_site_id

Line 120: CURSOR c_ship_to_site_id ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)

116: AND (NVL(use.end_date, SYSDATE));
117:
118: /* Bug 3917132
119: Cursor to get the Ship to Address */
120: CURSOR c_ship_to_site_id ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)
121: IS
122: SELECT use.party_site_use_id
123: FROM hz_party_sites site, hz_party_site_uses use
124:

Line 513: FROM CS_INCIDENTS_ALL_B

509: CURSOR c_last_update_date ( b_incident_id NUMBER )
510: IS
511: SELECT LAST_UPDATE_DATE,
512: LAST_UPDATED_BY
513: FROM CS_INCIDENTS_ALL_B
514: WHERE incident_id = b_incident_id;
515:
516: --115.10
517: CURSOR l_install_site_csr (p_customer_product_id IN number)

Line 1086: FROM CS_INCIDENTS_ALL_B b,

1082: l_user_name in varchar2,
1083: l_sequence in number)
1084: IS
1085: SELECT b.last_updated_by
1086: FROM CS_INCIDENTS_ALL_B b,
1087: CSM_INCIDENTS_ALL_INQ a
1088: WHERE a.clid$$cs = l_user_name
1089: AND tranid$$ = l_tran_id
1090: AND seqno$$ = l_sequence