APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_COA_HEADERS

Line 56: --| in the insert for gmd_coa_headers table |

52: --| as 5RJ does not exist |
53: --| Peter Lowe 04-AUG-2009 Bug 8733799 - changed procedure |
54: --| get_order_params - changed cursor c_order_delivery |
55: --| by adding extra join AND added a check for duplicates |
56: --| in the insert for gmd_coa_headers table |
57: --| Rajender Nalla 20-Aug-2009 Added the new where condition to the results|
58: --| and composite results to restrict delete marked rows |
59: --| Bug 8813052 |
60: --| Rajender Nalla 20-Aug-2009 Added the new where condition in |

Line 113: PrintLn('Inserting into gmd_coa_headers table');

109: X_login_id NUMBER:= FND_GLOBAL.LOGIN_ID;
110: BEGIN
111:
112: PrintLn('Begin procedure insert_hdr_rec');
113: PrintLn('Inserting into gmd_coa_headers table');
114: INSERT INTO gmd_coa_headers (gmd_coa_id,
115: order_id,
116: line_id,
117: organization_id, --INVCONV

Line 114: INSERT INTO gmd_coa_headers (gmd_coa_id,

110: BEGIN
111:
112: PrintLn('Begin procedure insert_hdr_rec');
113: PrintLn('Inserting into gmd_coa_headers table');
114: INSERT INTO gmd_coa_headers (gmd_coa_id,
115: order_id,
116: line_id,
117: organization_id, --INVCONV
118: organization_code, --INVCONV

Line 1799: SELECT LOT_NUMBER FROM GMD_COA_HEADERS WHERE LOT_NUMBER = P_LOT_NUMBER AND ORDER_QTY1 = P_ORDER_QTY1;

1795:
1796:
1797: -- 8733799
1798: CURSOR CHECK_DUP_LOT (P_LOT_NUMBER VARCHAR2, P_ORDER_QTY1 NUMBER) IS
1799: SELECT LOT_NUMBER FROM GMD_COA_HEADERS WHERE LOT_NUMBER = P_LOT_NUMBER AND ORDER_QTY1 = P_ORDER_QTY1;
1800:
1801: l_lot_number VARCHAR2(80); -- 8733799
1802: l_order_qty1 NUMBER; -- 8733799
1803:

Line 1915: -- fix for 8733799 - to check for duplicates in the gmd_coa_headers table

1911: END IF;
1912: PrintLn('hdr_rec.lot_number = '||hdr_rec.lot_number);
1913:
1914:
1915: -- fix for 8733799 - to check for duplicates in the gmd_coa_headers table
1916:
1917: -- check dup lot
1918: OPEN Check_Dup_Lot(hdr_rec.lot_number , hdr_rec.order_qty1);
1919: FETCH check_dup_lot INTO l_lot_number;

Line 2068: -- fix for 8733799 - to check for duplicates in the gmd_coa_headers table

2064: END IF;
2065: PrintLn('hdr_rec.lot_number = '||hdr_rec.lot_number);
2066:
2067:
2068: -- fix for 8733799 - to check for duplicates in the gmd_coa_headers table
2069:
2070: -- check dup lot
2071: OPEN Check_Dup_Lot(hdr_rec.lot_number , hdr_rec.order_qty1);
2072: FETCH check_dup_lot INTO l_lot_number;