DBA Data[Home] [Help]

APPS.CSI_T_TXN_OUS_PVT dependencies on CSI_T_ORG_ASSIGNMENTS_PKG

Line 135: p_pkg_name => 'csi_t_org_assignments_pkg');

131: begin
132:
133: csi_t_gen_utility_pvt.dump_api_info(
134: p_api_name => 'insert_row',
135: p_pkg_name => 'csi_t_org_assignments_pkg');
136:
137: csi_t_org_assignments_pkg.insert_row(
138: px_txn_operating_unit_id => l_txn_operating_unit_id,
139: p_txn_line_detail_id => p_txn_org_assgn_rec.txn_line_detail_id,

Line 137: csi_t_org_assignments_pkg.insert_row(

133: csi_t_gen_utility_pvt.dump_api_info(
134: p_api_name => 'insert_row',
135: p_pkg_name => 'csi_t_org_assignments_pkg');
136:
137: csi_t_org_assignments_pkg.insert_row(
138: px_txn_operating_unit_id => l_txn_operating_unit_id,
139: p_txn_line_detail_id => p_txn_org_assgn_rec.txn_line_detail_id,
140: p_operating_unit_id => p_txn_org_assgn_rec.operating_unit_id,
141: p_relationship_type_code => p_txn_org_assgn_rec.relationship_type_code,

Line 173: 'csi_t_org_assignments_pkg.insert_row Failed. '||substr(sqlerrm,1,200));

169: exception
170: when others then
171: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
172: fnd_message.set_token('MESSAGE',
173: 'csi_t_org_assignments_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
174: fnd_msg_pub.add;
175: raise fnd_api.g_exc_error;
176: end;
177:

Line 431: p_pkg_name => 'csi_t_org_assignments_pkg',

427: --debug info
428: begin
429:
430: csi_t_gen_utility_pvt.dump_api_info(
431: p_pkg_name => 'csi_t_org_assignments_pkg',
432: p_api_name => 'update_row');
433:
434: csi_t_org_assignments_pkg.update_row(
435: p_txn_operating_unit_id => l_ou_rec.txn_operating_unit_id,

Line 434: csi_t_org_assignments_pkg.update_row(

430: csi_t_gen_utility_pvt.dump_api_info(
431: p_pkg_name => 'csi_t_org_assignments_pkg',
432: p_api_name => 'update_row');
433:
434: csi_t_org_assignments_pkg.update_row(
435: p_txn_operating_unit_id => l_ou_rec.txn_operating_unit_id,
436: p_txn_line_detail_id => l_ou_rec.txn_line_detail_id,
437: p_operating_unit_id => l_ou_rec.operating_unit_id,
438: p_relationship_type_code=> l_ou_rec.relationship_type_code,

Line 470: 'csi_t_org_assignments_pkg.update_row failed. '||substr(sqlerrm,1,200));

466: exception
467: when others then
468: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
469: fnd_message.set_token('MESSAGE',
470: 'csi_t_org_assignments_pkg.update_row failed. '||substr(sqlerrm,1,200));
471: fnd_msg_pub.add;
472: raise fnd_api.g_exc_error;
473: end;
474:

Line 618: p_pkg_name => 'csi_t_org_assignments_pkg');

614:
615: --debug info
616: csi_t_gen_utility_pvt.dump_api_info(
617: p_api_name => 'delete_row',
618: p_pkg_name => 'csi_t_org_assignments_pkg');
619:
620: csi_t_org_assignments_pkg.delete_row(
621: p_txn_operating_unit_id => l_txn_ou_id);
622:

Line 620: csi_t_org_assignments_pkg.delete_row(

616: csi_t_gen_utility_pvt.dump_api_info(
617: p_api_name => 'delete_row',
618: p_pkg_name => 'csi_t_org_assignments_pkg');
619:
620: csi_t_org_assignments_pkg.delete_row(
621: p_txn_operating_unit_id => l_txn_ou_id);
622:
623: ELSE
624:

Line 651: p_pkg_name => 'csi_t_org_assignments_pkg');

647: LOOP
648:
649: csi_t_gen_utility_pvt.dump_api_info(
650: p_api_name => 'delete_row',
651: p_pkg_name => 'csi_t_org_assignments_pkg');
652:
653: csi_t_org_assignments_pkg.delete_row(
654: p_txn_operating_unit_id => ou_rec.txn_operating_unit_id);
655:

Line 653: csi_t_org_assignments_pkg.delete_row(

649: csi_t_gen_utility_pvt.dump_api_info(
650: p_api_name => 'delete_row',
651: p_pkg_name => 'csi_t_org_assignments_pkg');
652:
653: csi_t_org_assignments_pkg.delete_row(
654: p_txn_operating_unit_id => ou_rec.txn_operating_unit_id);
655:
656: END LOOP;
657: