DBA Data[Home] [Help]

APPS.PA_BILLING dependencies on FND_PROFILE

Line 264: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

260: t.ready_to_bill_flag);
261:
262: task_rec each_task%ROWTYPE;
263:
264: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
265:
266: BEGIN
267: IF g1_debug_mode = 'Y' THEN
268: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.bill_ext_driver :');

Line 438: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

434: X_request_id IN NUMBER DEFAULT NULL
435: ) IS
436:
437:
438: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
439:
440: budget_revenue REAL := 0;
441: budget_cost REAL := 0;
442: invoice_amount REAL := 0;

Line 827: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

823: X_rev_inv_num NUMBER DEFAULT NULL,
824: X_calling_process VARCHAR2) IS
825:
826:
827: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
828:
829: BEGIN
830:
831: -- Bug#1165176 Added condition line_num_reversed is null

Line 901: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

897: x_bill_txn_bill_rate out NOCOPY number, --File.Sql.39 bug 4440895
898: x_markup_percentage out NOCOPY number, --File.Sql.39 bug 4440895
899: x_rate_source_id out NOCOPY number ) IS --File.Sql.39 bug 4440895
900:
901: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
902:
903: BEGIN
904: /* Change the call and aded new paras in this procs. for MCB2 */
905: IF g1_debug_mode = 'Y' THEN

Line 977: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

973: l_project_id number;
974: l_project_level_funding_flag varchar2(2); /* added for bug 9649164 */
975:
976:
977: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
978:
979: /*--------------------------------------------------------------------------
980: | Cursor For Selecting AND Locking PA_PROJECTS TABLE |
981: --------------------------------------------------------------------------*/

Line 1398: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1394: || Revproc Writeoff Amount (OUT) ||
1395: --------------------------------------------------------------------------*/
1396:
1397:
1398: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1399: l_writeoff_amount NUMBER := p_writeoff_amount ;
1400:
1401: BEGIN
1402:

Line 1646: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1642: declare all the memory variables.
1643: --------------------------------------------------------------------------------------*/
1644:
1645:
1646: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1647:
1648: system_error EXCEPTION;
1649: amount number;
1650: rate_sch_rev_id number;

Line 2010: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

2006: || WriteOff Amount (IN) (OUT) ||
2007: || Rep Projfunc Writeoff Amount (OUT) ||
2008: --------------------------------------------------------------------------*/
2009:
2010: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2011: l_writeoff_amount NUMBER := px_writeoff_amount;
2012:
2013: BEGIN
2014:

Line 2106: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

2102: x_markup_percentage OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2103: x_rate_source_id OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
2104: IS
2105:
2106: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2107:
2108: l_amount NUMBER := x_amount;
2109: l_bill_rate_flag VARCHAR2(1) := x_bill_rate_flag;
2110:

Line 2190: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

2186:
2187: l_project_id number;
2188: l_Request_id number;
2189: l_project_level_funding_flag varchar2(2);
2190: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2191:
2192: CURSOR c_sel_proj is
2193: SELECT project_id, project_level_funding_flag
2194: FROM pa_projects_all