[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| This package contains the private database insert routines |
| for Process / Discrete Transfer only. |
| |
| CONTENTS |
| header_insert |
| line_insert |
| lot_insert |
| |
| |
| HISTORY |
| Created - Jalaj Srivastava |
| |
| |
+==========================================================================+
*/
PROCEDURE log_msg(p_msg_text IN VARCHAR2);
| header_insert |
| |
| USAGE |
| Sets up and insert records in gmi_discrete_transfers |
| |
| RETURNS |
| Via x_ OUT parameters |
| |
| HISTORY |
| Created Jalaj Srivastava |
| |
+==========================================================================+ */
PROCEDURE header_insert
( p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
, p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
, p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_hdr_rec IN GMIVDX.hdr_type
, x_hdr_row OUT NOCOPY gmi_discrete_transfers%ROWTYPE
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'header_insert' ;
SELECT gmi_dxfr_transfer_id_s.nextval INTO x_hdr_row.transfer_id FROM DUAL;
x_hdr_row.last_updated_by := FND_GLOBAL.USER_ID;
x_hdr_row.last_update_date := SYSDATE;
x_hdr_row.last_update_login := FND_GLOBAL.LOGIN_ID;
x_hdr_row.delete_mark := 0;
INSERT INTO gmi_discrete_transfers
( transfer_id
, orgn_code
, co_code
, transfer_number
, transfer_type
, trans_date
, comments
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, attribute16
, attribute17
, attribute18
, attribute19
, attribute20
, attribute21
, attribute22
, attribute23
, attribute24
, attribute25
, attribute26
, attribute27
, attribute28
, attribute29
, attribute30
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, delete_mark
, text_code
)
VALUES
( x_hdr_row.transfer_id
, x_hdr_row.orgn_code
, x_hdr_row.co_code
, x_hdr_row.transfer_number
, x_hdr_row.transfer_type
, x_hdr_row.trans_date
, x_hdr_row.comments
, x_hdr_row.attribute_category
, x_hdr_row.attribute1
, x_hdr_row.attribute2
, x_hdr_row.attribute3
, x_hdr_row.attribute4
, x_hdr_row.attribute5
, x_hdr_row.attribute6
, x_hdr_row.attribute7
, x_hdr_row.attribute8
, x_hdr_row.attribute9
, x_hdr_row.attribute10
, x_hdr_row.attribute11
, x_hdr_row.attribute12
, x_hdr_row.attribute13
, x_hdr_row.attribute14
, x_hdr_row.attribute15
, x_hdr_row.attribute16
, x_hdr_row.attribute17
, x_hdr_row.attribute18
, x_hdr_row.attribute19
, x_hdr_row.attribute20
, x_hdr_row.attribute21
, x_hdr_row.attribute22
, x_hdr_row.attribute23
, x_hdr_row.attribute24
, x_hdr_row.attribute25
, x_hdr_row.attribute26
, x_hdr_row.attribute27
, x_hdr_row.attribute28
, x_hdr_row.attribute29
, x_hdr_row.attribute30
, x_hdr_row.created_by
, x_hdr_row.creation_date
, x_hdr_row.last_updated_by
, x_hdr_row.last_update_date
, x_hdr_row.last_update_login
, x_hdr_row.delete_mark
, x_hdr_row.text_code
);
log_msg('Inserted 1 record in gmi_discrete_transfers');
END header_insert;
| line_insert |
| |
| USAGE |
| Sets up and insert records in gmi_discrete_transfer_lines |
| |
| RETURNS |
| Via x_ OUT parameters |
| |
| HISTORY |
| Created Jalaj Srivastava |
| |
+==========================================================================+
*/
PROCEDURE line_insert
( p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
, p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
, p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_hdr_row IN gmi_discrete_transfers%ROWTYPE
, p_line_rec IN GMIVDX.line_type
, x_line_row OUT NOCOPY gmi_discrete_transfer_lines%ROWTYPE
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'line_insert' ;
SELECT gmi_dxfr_line_id_s.nextval INTO x_line_row.line_id FROM DUAL;
x_line_row.last_updated_by := FND_GLOBAL.USER_ID;
x_line_row.last_update_date := SYSDATE;
x_line_row.last_update_login := FND_GLOBAL.LOGIN_ID;
x_line_row.delete_mark := 0;
INSERT INTO gmi_discrete_transfer_lines
(
transfer_id
, line_id
, line_no
, opm_item_id
, opm_whse_code
, opm_location
, opm_lot_id
, opm_lot_expiration_date
, opm_lot_status
, opm_grade
, opm_charge_acct_id
, opm_charge_au_id
, opm_reason_code
, odm_inv_organization_id
, odm_item_id
, odm_item_revision
, odm_subinventory
, odm_locator_id
, odm_lot_number
, odm_lot_expiration_date
, odm_charge_account_id
, odm_period_id
, odm_unit_cost
, odm_reason_id
, quantity
, quantity_um
, quantity2
, opm_primary_quantity
, odm_primary_quantity
, lot_level
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, attribute16
, attribute17
, attribute18
, attribute19
, attribute20
, attribute21
, attribute22
, attribute23
, attribute24
, attribute25
, attribute26
, attribute27
, attribute28
, attribute29
, attribute30
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, delete_mark
, text_code
)
VALUES
(
x_line_row.transfer_id
, x_line_row.line_id
, x_line_row.line_no
, x_line_row.opm_item_id
, x_line_row.opm_whse_code
, x_line_row.opm_location
, x_line_row.opm_lot_id
, x_line_row.opm_lot_expiration_date
, x_line_row.opm_lot_status
, x_line_row.opm_grade
, x_line_row.opm_charge_acct_id
, x_line_row.opm_charge_au_id
, x_line_row.opm_reason_code
, x_line_row.odm_inv_organization_id
, x_line_row.odm_item_id
, x_line_row.odm_item_revision
, x_line_row.odm_subinventory
, x_line_row.odm_locator_id
, x_line_row.odm_lot_number
, x_line_row.odm_lot_expiration_date
, x_line_row.odm_charge_account_id
, x_line_row.odm_period_id
, x_line_row.odm_unit_cost
, x_line_row.odm_reason_id
, x_line_row.quantity
, x_line_row.quantity_um
, x_line_row.quantity2
, x_line_row.opm_primary_quantity
, x_line_row.odm_primary_quantity
, x_line_row.lot_level
, x_line_row.attribute_category
, x_line_row.attribute1
, x_line_row.attribute2
, x_line_row.attribute3
, x_line_row.attribute4
, x_line_row.attribute5
, x_line_row.attribute6
, x_line_row.attribute7
, x_line_row.attribute8
, x_line_row.attribute9
, x_line_row.attribute10
, x_line_row.attribute11
, x_line_row.attribute12
, x_line_row.attribute13
, x_line_row.attribute14
, x_line_row.attribute15
, x_line_row.attribute16
, x_line_row.attribute17
, x_line_row.attribute18
, x_line_row.attribute19
, x_line_row.attribute20
, x_line_row.attribute21
, x_line_row.attribute22
, x_line_row.attribute23
, x_line_row.attribute24
, x_line_row.attribute25
, x_line_row.attribute26
, x_line_row.attribute27
, x_line_row.attribute28
, x_line_row.attribute29
, x_line_row.attribute30
, x_line_row.created_by
, x_line_row.creation_date
, x_line_row.last_updated_by
, x_line_row.last_update_date
, x_line_row.last_update_login
, x_line_row.delete_mark
, x_line_row.text_code
);
log_msg('Inserted 1 record in gmi_discrete_transfer_lines');
END line_insert;
| lot_insert |
| |
| USAGE |
| Sets up and insert records in gmi_discrete_transfer_lots |
| |
| RETURNS |
| Via x_ OUT parameters |
| |
| HISTORY |
| Created Jalaj Srivastava |
| |
+==========================================================================+
*/
PROCEDURE lot_insert
( p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
, p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
, p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_line_row IN gmi_discrete_transfer_lines%ROWTYPE
, p_lot_rec IN GMIVDX.lot_type
, x_lot_row OUT NOCOPY gmi_discrete_transfer_lots%ROWTYPE
) IS
l_api_name CONSTANT VARCHAR2(30) := 'lot_insert' ;
SELECT gmi_dxfr_line_detail_id_s.nextval INTO x_lot_row.line_detail_id FROM DUAL;
x_lot_row.last_updated_by := FND_GLOBAL.USER_ID;
x_lot_row.last_update_date := SYSDATE;
x_lot_row.last_update_login := FND_GLOBAL.LOGIN_ID;
x_lot_row.delete_mark := 0;
INSERT INTO gmi_discrete_transfer_lots
(
transfer_id
, line_id
, line_detail_id
, opm_lot_id
, opm_lot_expiration_date
, opm_lot_status
, opm_grade
, odm_lot_number
, odm_lot_expiration_date
, quantity
, quantity2
, opm_primary_quantity
, odm_primary_quantity
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, delete_mark
, text_code
)
VALUES
(
x_lot_row.transfer_id
, x_lot_row.line_id
, x_lot_row.line_detail_id
, x_lot_row.opm_lot_id
, x_lot_row.opm_lot_expiration_date
, x_lot_row.opm_lot_status
, x_lot_row.opm_grade
, x_lot_row.odm_lot_number
, x_lot_row.odm_lot_expiration_date
, x_lot_row.quantity
, x_lot_row.quantity2
, x_lot_row.opm_primary_quantity
, x_lot_row.odm_primary_quantity
, x_lot_row.created_by
, x_lot_row.creation_date
, x_lot_row.last_updated_by
, x_lot_row.last_update_date
, x_lot_row.last_update_login
, x_lot_row.delete_mark
, x_lot_row.text_code
);
log_msg('Inserted 1 record in gmi_discrete_transfer_lots');
END lot_insert;