[Home] [Help]
90: l_params wip_logger.param_tbl_t;
91:
92: l_fromUI NUMBER;--> 0 if the record originated from oracle user interfaces
93:
94: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
95: l_src_code VARCHAR2(2000);
96: l_errMsg VARCHAR2(50); /* Fix for Bug#5187500. Changed it to 50 */
97: l_bf_count NUMBER ; /* Fix for Bug#5187500 */
98: l_lot_ser_count NUMBER ; /* Fix for Bug#5187500 */
714: l_service_item_flag varchar2(1) ; /*BUG 6134576*/
715:
716: l_params wip_logger.param_tbl_t;
717: l_returnStatus varchar2(1);
718: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
719: l_errMsg VARCHAR2(2000);
720:
721: cursor wfs_info_cursor(wipEntityId number) is
722: select wip_entity_id,
1436: l_overheadVarianceAccount number ;
1437:
1438: l_params wip_logger.param_tbl_t;
1439: l_returnStatus varchar2(1);
1440: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1441:
1442: l_prjID NUMBER;
1443: l_tskID NUMBER;
1444:
1807: l_newCompletedQty number;
1808:
1809: l_params wip_logger.param_tbl_t;
1810: l_returnStatus varchar2(1);
1811: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1812: begin
1813:
1814: if (l_logLevel <= wip_constants.trace_logging) then
1815: l_params(1).paramName := 'p_txnTempID';
1981: l_commonRoutSeqID number;
1982: l_checkPass boolean;
1983: l_lineOpTbl bom_rtg_network_api.op_tbl_type;
1984: l_constructed boolean := false;
1985: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1986: l_success boolean;
1987: l_locatorID number := null;
1988:
1989: l_includeYield NUMBER; /*Component Yield Enhancement(Bug 4369064)*/
2275: l_openPastPeriod boolean := false;
2276:
2277: l_params wip_logger.param_tbl_t;
2278: l_returnStatus varchar2(1);
2279: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2280: begin
2281:
2282: if (l_logLevel <= wip_constants.trace_logging) then
2283: l_params(1).paramName := 'p_txnTempID';
2683: l_srcTaskID number;
2684: l_wipEntityID number;
2685: l_projRefEnabled number;
2686: l_orgLocControl number := 0;
2687: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2688: begin
2689: if (l_logLevel <= wip_constants.trace_logging) then
2690: l_params(1).paramName := 'p_parentID';
2691: l_params(1).paramValue := p_parentID;