APPS.PN_PURGE_INTERFACE_PKG dependencies on PN_LOCATIONS_ITF

Line 72: From PN_LOCATIONS_ITF

68: BEGIN
69: IF P_BATCH_NAME is not null then /* IF and ELSIF has been added for the BUG#1850937 */
70: Select Count(*)
71: Into l_Count
72: From PN_LOCATIONS_ITF
73: Where Batch_Name = p_Batch_Name ;
74: ELSIF P_BATCH_NAME IS NULL then
75: Select Count(*)
76: Into l_Count

Line 77: From PN_LOCATIONS_ITF;

73: Where Batch_Name = p_Batch_Name ;
74: ELSIF P_BATCH_NAME IS NULL then
75: Select Count(*)
76: Into l_Count
77: From PN_LOCATIONS_ITF;
78: END IF;
79:
80:
81: If (l_Debug = 'Y') Then

Line 82: pnp_debug_pkg.log('About to Delete from PN_LOCATIONS_ITF ...');

78: END IF;
79:
80:
81: If (l_Debug = 'Y') Then
82: pnp_debug_pkg.log('About to Delete from PN_LOCATIONS_ITF ...');
83: End If;
84: IF P_BATCH_NAME is not null then /* IF and ELSIF has been added for the BUG#1850937 */
85: Delete From PN_LOCATIONS_ITF
86: Where Batch_Name = p_Batch_Name ;

Line 85: Delete From PN_LOCATIONS_ITF

81: If (l_Debug = 'Y') Then
82: pnp_debug_pkg.log('About to Delete from PN_LOCATIONS_ITF ...');
83: End If;
84: IF P_BATCH_NAME is not null then /* IF and ELSIF has been added for the BUG#1850937 */
85: Delete From PN_LOCATIONS_ITF
86: Where Batch_Name = p_Batch_Name ;
87: ELSIF P_BATCH_NAME IS NULL then
88: Delete From PN_LOCATIONS_ITF;
89: END IF;

Line 88: Delete From PN_LOCATIONS_ITF;

84: IF P_BATCH_NAME is not null then /* IF and ELSIF has been added for the BUG#1850937 */
85: Delete From PN_LOCATIONS_ITF
86: Where Batch_Name = p_Batch_Name ;
87: ELSIF P_BATCH_NAME IS NULL then
88: Delete From PN_LOCATIONS_ITF;
89: END IF;
90:
91: pnp_debug_pkg.log('Table: PN_LOCATIONS_ITF');
92:

Line 91: pnp_debug_pkg.log('Table: PN_LOCATIONS_ITF');

87: ELSIF P_BATCH_NAME IS NULL then
88: Delete From PN_LOCATIONS_ITF;
89: END IF;
90:
91: pnp_debug_pkg.log('Table: PN_LOCATIONS_ITF');
92:
93: fnd_message.set_name ('PN','PN_BATCH_NAME');
94: fnd_message.set_token ('NAME',p_batch_name);
95: pnp_debug_pkg.put_log_msg(fnd_message.get);