DBA Data[Home] [Help]

APPS.GME_API_MAIN dependencies on GME_PENDING_PRODUCT_LOTS

Line 4198: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

4194: ,x_message_count OUT NOCOPY NUMBER
4195: ,x_message_list OUT NOCOPY VARCHAR2
4196: ,x_return_status OUT NOCOPY VARCHAR2
4197: ,p_org_id IN NUMBER
4198: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
4199: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
4200: IS
4201: l_api_name CONSTANT VARCHAR2 (30) := 'create_pending_product_lot';
4202: setup_failure EXCEPTION;

Line 4199: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)

4195: ,x_message_list OUT NOCOPY VARCHAR2
4196: ,x_return_status OUT NOCOPY VARCHAR2
4197: ,p_org_id IN NUMBER
4198: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
4199: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)
4200: IS
4201: l_api_name CONSTANT VARCHAR2 (30) := 'create_pending_product_lot';
4202: setup_failure EXCEPTION;
4203: create_pp_lot_failure EXCEPTION;

Line 4236: gme_pending_product_lots_pvt.create_pending_product_lot

4232: gme_common_pvt.g_error_count := 0;
4233: END IF;
4234:
4235: gme_common_pvt.set_timestamp;
4236: gme_pending_product_lots_pvt.create_pending_product_lot
4237: (p_pending_product_lots_rec => p_pending_product_lots_rec
4238: ,x_pending_product_lots_rec => x_pending_product_lots_rec
4239: ,x_return_status => x_return_status);
4240:

Line 4302: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

4298: ,x_message_count OUT NOCOPY NUMBER
4299: ,x_message_list OUT NOCOPY VARCHAR2
4300: ,x_return_status OUT NOCOPY VARCHAR2
4301: ,p_org_id IN NUMBER
4302: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
4303: ,x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE)
4304: IS
4305: l_api_name CONSTANT VARCHAR2 (30) := 'update_pending_product_lot';
4306: setup_failure EXCEPTION;

Line 4303: ,x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE)

4299: ,x_message_list OUT NOCOPY VARCHAR2
4300: ,x_return_status OUT NOCOPY VARCHAR2
4301: ,p_org_id IN NUMBER
4302: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
4303: ,x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE)
4304: IS
4305: l_api_name CONSTANT VARCHAR2 (30) := 'update_pending_product_lot';
4306: setup_failure EXCEPTION;
4307: update_pp_lot_failure EXCEPTION;

Line 4340: gme_pending_product_lots_pvt.update_pending_product_lot

4336: gme_common_pvt.g_error_count := 0;
4337: END IF;
4338:
4339: gme_common_pvt.set_timestamp;
4340: gme_pending_product_lots_pvt.update_pending_product_lot
4341: (p_pending_product_lots_rec => p_pending_product_lots_rec
4342: ,x_pending_product_lots_rec => x_pending_product_lots_rec
4343: ,x_return_status => x_return_status);
4344:

Line 4407: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)

4403: ,x_message_count OUT NOCOPY NUMBER
4404: ,x_message_list OUT NOCOPY VARCHAR2
4405: ,x_return_status OUT NOCOPY VARCHAR2
4406: ,p_org_id IN NUMBER
4407: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)
4408: IS
4409: l_api_name CONSTANT VARCHAR2 (30) := 'delete_pending_product_lot';
4410: setup_failure EXCEPTION;
4411: delete_pp_lot_failure EXCEPTION;

Line 4444: gme_pending_product_lots_pvt.delete_pending_product_lot

4440: gme_common_pvt.g_error_count := 0;
4441: END IF;
4442:
4443: gme_common_pvt.set_timestamp;
4444: gme_pending_product_lots_pvt.delete_pending_product_lot
4445: (p_pending_product_lots_rec => p_pending_product_lots_rec
4446: ,x_return_status => x_return_status);
4447:
4448: IF x_return_status <> fnd_api.g_ret_sts_success THEN