DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on CSF_DEBRIEF_UPDATE_PKG

Line 1: PACKAGE BODY CSF_DEBRIEF_UPDATE_PKG as

1: PACKAGE BODY CSF_DEBRIEF_UPDATE_PKG as
2: /* $Header: csfuppdb.pls 120.34.12020000.9 2013/04/09 10:35:49 shadas ship $ */
3:
4: -- Start of Comments
5: -- Package name : CSF_DEBRIEF_UPDATE_PKG

Line 5: -- Package name : CSF_DEBRIEF_UPDATE_PKG

1: PACKAGE BODY CSF_DEBRIEF_UPDATE_PKG as
2: /* $Header: csfuppdb.pls 120.34.12020000.9 2013/04/09 10:35:49 shadas ship $ */
3:
4: -- Start of Comments
5: -- Package name : CSF_DEBRIEF_UPDATE_PKG
6: -- Purpose :
7: -- History :
8: -- NOTE :
9: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_UPDATE_PKG';

7: -- History :
8: -- NOTE :
9: -- End of Comments
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_UPDATE_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csfuppdb.pls';
13: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
15: G_UPDATE NUMBER := 1;

Line 26: 'csf.plsql.csf_debrief_update_pkg.'||p_procedure,

22: begin
23: -- dbms_output.put_line(p_procedure||' - '||p_message);
24: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
25: fnd_log.string(fnd_log.level_statement,
26: 'csf.plsql.csf_debrief_update_pkg.'||p_procedure,
27: p_message);
28: end if;
29: end;
30:

Line 1270: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_UPDATE_PKG',

1266: or (l_ib_update_status = 'SUCCEEDED' and l_trackable ='Y')
1267: or l_trackable ='N' or l_trackable is null ) Then
1268:
1269: l_return_status := fnd_api.g_ret_sts_success;
1270: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_UPDATE_PKG',
1271: 'TRANSACT_MATERIAL','B','C') THEN
1272: csf_debrief_update_pkg.g_debrief_line_id := l_debrief_line_id;
1273: csf_debrief_update_pkg.g_account_id := null;
1274: csf_debrief_pub.call_internal_hook('CSF_DEBRIEF_UPDATE_PKG',

Line 1272: csf_debrief_update_pkg.g_debrief_line_id := l_debrief_line_id;

1268:
1269: l_return_status := fnd_api.g_ret_sts_success;
1270: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_UPDATE_PKG',
1271: 'TRANSACT_MATERIAL','B','C') THEN
1272: csf_debrief_update_pkg.g_debrief_line_id := l_debrief_line_id;
1273: csf_debrief_update_pkg.g_account_id := null;
1274: csf_debrief_pub.call_internal_hook('CSF_DEBRIEF_UPDATE_PKG',
1275: 'TRANSACT_MATERIAL','B',
1276: l_return_status);

Line 1273: csf_debrief_update_pkg.g_account_id := null;

1269: l_return_status := fnd_api.g_ret_sts_success;
1270: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_UPDATE_PKG',
1271: 'TRANSACT_MATERIAL','B','C') THEN
1272: csf_debrief_update_pkg.g_debrief_line_id := l_debrief_line_id;
1273: csf_debrief_update_pkg.g_account_id := null;
1274: csf_debrief_pub.call_internal_hook('CSF_DEBRIEF_UPDATE_PKG',
1275: 'TRANSACT_MATERIAL','B',
1276: l_return_status);
1277: end if;

Line 1274: csf_debrief_pub.call_internal_hook('CSF_DEBRIEF_UPDATE_PKG',

1270: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_UPDATE_PKG',
1271: 'TRANSACT_MATERIAL','B','C') THEN
1272: csf_debrief_update_pkg.g_debrief_line_id := l_debrief_line_id;
1273: csf_debrief_update_pkg.g_account_id := null;
1274: csf_debrief_pub.call_internal_hook('CSF_DEBRIEF_UPDATE_PKG',
1275: 'TRANSACT_MATERIAL','B',
1276: l_return_status);
1277: end if;
1278: log('main','after hook l_return_status:'||l_return_status);

Line 1321: p_account_id => csf_debrief_update_pkg.g_account_id,

1317: p_transfer_to_organization => null,
1318: p_source_id => null,
1319: p_source_line_id => null,
1320: p_transaction_type_id => l_inv_transaction_type_id,
1321: p_account_id => csf_debrief_update_pkg.g_account_id,
1322: px_transaction_header_id => l_inv_transaction_header_id,
1323: px_transaction_id => l_inv_transaction_id,
1324: p_transaction_source_id => l_debrief_header_id,
1325: p_trx_source_line_id => l_debrief_line_id,

Line 1643: csf_debrief_update_pkg.relieve_reservations ( l_task_assignment_id ,

1639:
1640: -- relieve the reservations
1641: if l_qty_to_relieve > 0 then
1642: log('main', 'relieve_reservations for item: '||l_res_item_id);
1643: csf_debrief_update_pkg.relieve_reservations ( l_task_assignment_id ,
1644: l_res_item_id,
1645: l_qty_to_relieve,
1646: l_res_item_uom,
1647: l_return_status,

Line 2019: End Csf_Debrief_Update_pkg;

2015: fnd_msg_pub.add;
2016: x_return_status := fnd_api.g_ret_sts_unexp_error;
2017: END DEBRIEF_STATUS_CHECK ;
2018:
2019: End Csf_Debrief_Update_pkg;
2020: