APPS.BOM_BULKLOAD_PVT_PKG dependencies on BOM_BULKLOAD_PVT_PKG

Line 1: PACKAGE BODY BOM_BULKLOAD_PVT_PKG AS

1: PACKAGE BODY BOM_BULKLOAD_PVT_PKG AS
2: /* $Header: BOMBBLPB.pls 120.40.12020000.2 2012/07/13 01:44:13 mshirkol ship $ */
3:
4: -- =================================================================
5: -- Global variables used in the package.

Line 1007: l_dyn_sql := l_dyn_sql || ' to_char(BOM_BULKLOAD_PVT_PKG.displayDT_to_date(EBI.' || l_eff_date_col_name;

1003: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI SET';
1004: IF l_eff_date_col_name IS NOT NULL THEN
1005: l_dyn_sql := l_dyn_sql || ' EBI.'|| l_eff_date_col_name;
1006: l_dyn_sql := l_dyn_sql || ' = decode(EBI.'|| l_eff_date_col_name || ', NULL, NULL,';
1007: l_dyn_sql := l_dyn_sql || ' to_char(BOM_BULKLOAD_PVT_PKG.displayDT_to_date(EBI.' || l_eff_date_col_name;
1008: l_dyn_sql := l_dyn_sql || ' ,2),''DD-MON-YYYY HH24:MI:SS'')) ' ; -- Changed for bug 11735632
1009: END IF;
1010: IF l_dis_date_col_name IS NOT NULL THEN
1011: IF l_eff_date_col_name IS NOT NULL THEN

Line 1016: l_dyn_sql := l_dyn_sql || ' to_char(BOM_BULKLOAD_PVT_PKG.displayDT_to_date(EBI.' || l_dis_date_col_name;

1012: l_dyn_sql := l_dyn_sql || ' , ' ;
1013: END IF;
1014: l_dyn_sql := l_dyn_sql || ' EBI.'|| l_dis_date_col_name;
1015: l_dyn_sql := l_dyn_sql || ' = decode(EBI.'|| l_dis_date_col_name || ', NULL, NULL,';
1016: l_dyn_sql := l_dyn_sql || ' to_char(BOM_BULKLOAD_PVT_PKG.displayDT_to_date(EBI.' || l_dis_date_col_name;
1017: l_dyn_sql := l_dyn_sql || ' ,2),''DD-MON-YYYY HH24:MI:SS'')) ' ; -- Changed for bug 11735632
1018: END IF;
1019: IF l_imp_date_col_name IS NOT NULL THEN
1020: IF (l_eff_date_col_name IS NOT NULL OR l_dis_date_col_name IS NOT NULL) THEN

Line 1025: l_dyn_sql := l_dyn_sql || ' to_char(BOM_BULKLOAD_PVT_PKG.displayDT_to_date(EBI.' || l_imp_date_col_name;

1021: l_dyn_sql := l_dyn_sql || ' , ' ;
1022: END IF;
1023: l_dyn_sql := l_dyn_sql || ' EBI.'|| l_imp_date_col_name;
1024: l_dyn_sql := l_dyn_sql || ' = decode(EBI.'|| l_imp_date_col_name || ', NULL, NULL,';
1025: l_dyn_sql := l_dyn_sql || ' to_char(BOM_BULKLOAD_PVT_PKG.displayDT_to_date(EBI.' || l_imp_date_col_name;
1026: l_dyn_sql := l_dyn_sql || ' ,2),''DD-MON-YYYY HH24:MI:SS'')) ' ;
1027: END IF;
1028:
1029: l_dyn_sql := l_dyn_sql || ' WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 2698: END BOM_BULKLOAD_PVT_PKG;

2694: RAISE;
2695:
2696: END load_comp_usr_attr_interface;
2697:
2698: END BOM_BULKLOAD_PVT_PKG;