APPS.PN_PURGE_INTERFACE_PKG dependencies on PN_EMP_SPACE_ASSIGN_ITF

Line 119: From PN_EMP_SPACE_ASSIGN_ITF

115: BEGIN
116: IF P_BATCH_NAME is not null then /* IF and ELSIF has been added for the BUG#1850937 */
117: Select Count(*)
118: Into l_Count
119: From PN_EMP_SPACE_ASSIGN_ITF
120: Where Batch_Name = p_Batch_Name ;
121: ELSIF P_BATCH_NAME IS NULL then
122: Select Count(*)
123: Into l_Count

Line 124: From PN_EMP_SPACE_ASSIGN_ITF;

120: Where Batch_Name = p_Batch_Name ;
121: ELSIF P_BATCH_NAME IS NULL then
122: Select Count(*)
123: Into l_Count
124: From PN_EMP_SPACE_ASSIGN_ITF;
125: END IF;
126: If (l_Debug = 'Y') Then
127: pnp_debug_pkg.log('About to Delete from PN_EMP_SPACE_ASSIGN_ITF ...');
128: End If;

Line 127: pnp_debug_pkg.log('About to Delete from PN_EMP_SPACE_ASSIGN_ITF ...');

123: Into l_Count
124: From PN_EMP_SPACE_ASSIGN_ITF;
125: END IF;
126: If (l_Debug = 'Y') Then
127: pnp_debug_pkg.log('About to Delete from PN_EMP_SPACE_ASSIGN_ITF ...');
128: End If;
129:
130: IF P_BATCH_NAME is not null then /* IF and ELSIF has been added for the BUG#1850937 */
131: Delete From PN_EMP_SPACE_ASSIGN_ITF

Line 131: Delete From PN_EMP_SPACE_ASSIGN_ITF

127: pnp_debug_pkg.log('About to Delete from PN_EMP_SPACE_ASSIGN_ITF ...');
128: End If;
129:
130: IF P_BATCH_NAME is not null then /* IF and ELSIF has been added for the BUG#1850937 */
131: Delete From PN_EMP_SPACE_ASSIGN_ITF
132: Where Batch_Name = p_Batch_Name ;
133: ELSIF P_BATCH_NAME is null then
134: Delete From PN_EMP_SPACE_ASSIGN_ITF;
135: END IF;

Line 134: Delete From PN_EMP_SPACE_ASSIGN_ITF;

130: IF P_BATCH_NAME is not null then /* IF and ELSIF has been added for the BUG#1850937 */
131: Delete From PN_EMP_SPACE_ASSIGN_ITF
132: Where Batch_Name = p_Batch_Name ;
133: ELSIF P_BATCH_NAME is null then
134: Delete From PN_EMP_SPACE_ASSIGN_ITF;
135: END IF;
136:
137: pnp_debug_pkg.log('Table: PN_EMP_SPACE_ASSIGN_ITF');
138: fnd_message.set_name ('PN','PN_BATCH_NAME');

Line 137: pnp_debug_pkg.log('Table: PN_EMP_SPACE_ASSIGN_ITF');

133: ELSIF P_BATCH_NAME is null then
134: Delete From PN_EMP_SPACE_ASSIGN_ITF;
135: END IF;
136:
137: pnp_debug_pkg.log('Table: PN_EMP_SPACE_ASSIGN_ITF');
138: fnd_message.set_name ('PN','PN_BATCH_NAME');
139: fnd_message.set_token ('NAME',p_batch_name);
140: pnp_debug_pkg.put_log_msg(fnd_message.get);
141: