139:
140: -- assign p_pick_header_rec.picklist_header_id to x_picklist_header_id
141: x_picklist_header_id := p_pick_header_rec.picklist_header_id;
142:
143: -- Invoke table handler(CSP_PICKLIST_HEADERS_PKG.Insert_Row)
144: CSP_PICKLIST_HEADERS_PKG.Insert_Row(
145: px_picklist_header_id => x_picklist_header_id,
146: p_CREATED_BY => p_PICK_HEADER_rec.CREATED_BY,
147: p_CREATION_DATE => p_PICK_HEADER_rec.CREATION_DATE,
140: -- assign p_pick_header_rec.picklist_header_id to x_picklist_header_id
141: x_picklist_header_id := p_pick_header_rec.picklist_header_id;
142:
143: -- Invoke table handler(CSP_PICKLIST_HEADERS_PKG.Insert_Row)
144: CSP_PICKLIST_HEADERS_PKG.Insert_Row(
145: px_picklist_header_id => x_picklist_header_id,
146: p_CREATED_BY => p_PICK_HEADER_rec.CREATED_BY,
147: p_CREATION_DATE => p_PICK_HEADER_rec.CREATION_DATE,
148: p_LAST_UPDATED_BY => p_PICK_HEADER_rec.LAST_UPDATED_BY,
461:
462: -- Debug Message
463: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
464:
465: -- Invoke table handler(CSP_PICKLIST_HEADERS_PKG.Update_Row)
466: CSP_PICKLIST_HEADERS_PKG.Update_Row(
467: p_picklist_header_id => p_PICK_HEADER_rec.picklist_header_id,
468: p_CREATED_BY => p_PICK_HEADER_rec.CREATED_BY,
469: p_CREATION_DATE => p_PICK_HEADER_rec.CREATION_DATE,
462: -- Debug Message
463: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
464:
465: -- Invoke table handler(CSP_PICKLIST_HEADERS_PKG.Update_Row)
466: CSP_PICKLIST_HEADERS_PKG.Update_Row(
467: p_picklist_header_id => p_PICK_HEADER_rec.picklist_header_id,
468: p_CREATED_BY => p_PICK_HEADER_rec.CREATED_BY,
469: p_CREATION_DATE => p_PICK_HEADER_rec.CREATION_DATE,
470: p_LAST_UPDATED_BY => p_PICK_HEADER_rec.LAST_UPDATED_BY ,
645: */
646: -- Debug Message
647: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
648:
649: -- Invoke table handler(CSP_PICKLIST_HEADERS_PKG.Delete_Row)
650: CSP_PICKLIST_HEADERS_PKG.Delete_Row(
651: p_picklist_header_id => p_PICK_HEADER_rec.picklist_header_id);
652: --
653: -- End of API body
646: -- Debug Message
647: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
648:
649: -- Invoke table handler(CSP_PICKLIST_HEADERS_PKG.Delete_Row)
650: CSP_PICKLIST_HEADERS_PKG.Delete_Row(
651: p_picklist_header_id => p_PICK_HEADER_rec.picklist_header_id);
652: --
653: -- End of API body
654: --