APPS.GME_VALIDATE_FLEX_FLD_PVT dependencies on GME_RESOURCE_TXNS

Line 2966: p_resource_txn_rec IN gme_resource_txns%ROWTYPE

2962: --- 16-March-2005 Punit Kumar Created new procedure
2963: --- 20-OCT-2005 added new parameter
2964: ======================================================================= */
2965: PROCEDURE validate_rsrc_txn_flex (
2966: p_resource_txn_rec IN gme_resource_txns%ROWTYPE
2967: ,x_resource_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
2968: ,x_return_status OUT NOCOPY VARCHAR2)
2969: IS
2970: l_attribute_category VARCHAR2 (240);

Line 2967: ,x_resource_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE

2963: --- 20-OCT-2005 added new parameter
2964: ======================================================================= */
2965: PROCEDURE validate_rsrc_txn_flex (
2966: p_resource_txn_rec IN gme_resource_txns%ROWTYPE
2967: ,x_resource_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
2968: ,x_return_status OUT NOCOPY VARCHAR2)
2969: IS
2970: l_attribute_category VARCHAR2 (240);
2971: appl_short_name VARCHAR2 (30) := 'GME';

Line 2987: l_resource_txn_rec gme_resource_txns%ROWTYPE;

2983: --3556979
2984: l_exists NUMBER;
2985: l_dummy BOOLEAN;
2986: /*start, Punit Kumar*/
2987: l_resource_txn_rec gme_resource_txns%ROWTYPE;
2988:
2989: /*end */
2990: CURSOR cur_record_exists (v_rec_id NUMBER)
2991: IS

Line 2993: FROM gme_resource_txns

2989: /*end */
2990: CURSOR cur_record_exists (v_rec_id NUMBER)
2991: IS
2992: SELECT 1
2993: FROM gme_resource_txns
2994: WHERE poc_trans_id = v_rec_id;
2995: BEGIN
2996: /* Set return status to success initially */
2997: x_return_status := fnd_api.g_ret_sts_success;

Line 3029: gme_resource_txns_dbl.fetch_row (p_resource_txn_rec

3025: IF cur_record_exists%NOTFOUND THEN
3026: l_resource_txn_rec := p_resource_txn_rec;
3027: ELSE
3028: l_dummy :=
3029: gme_resource_txns_dbl.fetch_row (p_resource_txn_rec
3030: ,l_resource_txn_rec);
3031: END IF;
3032:
3033: CLOSE cur_record_exists;

Line 6731: p_resource_txns IN gme_resource_txns%ROWTYPE,

6727: -- This procedure will assign the default values of the segments into the columns.
6728: --
6729: -- SYNOPSIS:
6730: create_flex_resource_txns (
6731: p_resource_txns IN gme_resource_txns%ROWTYPE,
6732: x_resource_txns IN OUT NOCOPY gme_resource_txns%ROWTYPE,
6733: x_return_status OUT NOCOPY VARCHAR2
6734: );
6735: -- HISTORY

Line 6732: x_resource_txns IN OUT NOCOPY gme_resource_txns%ROWTYPE,

6728: --
6729: -- SYNOPSIS:
6730: create_flex_resource_txns (
6731: p_resource_txns IN gme_resource_txns%ROWTYPE,
6732: x_resource_txns IN OUT NOCOPY gme_resource_txns%ROWTYPE,
6733: x_return_status OUT NOCOPY VARCHAR2
6734: );
6735: -- HISTORY
6736: -- Sivakumar.G 03-NOV-2005 Created --BUG#4395561

Line 6739: p_resource_txns IN gme_resource_txns%ROWTYPE,

6735: -- HISTORY
6736: -- Sivakumar.G 03-NOV-2005 Created --BUG#4395561
6737: ======================================================================= */
6738: PROCEDURE create_flex_resource_txns (
6739: p_resource_txns IN gme_resource_txns%ROWTYPE,
6740: x_resource_txns IN OUT NOCOPY gme_resource_txns%ROWTYPE,
6741: x_return_status OUT NOCOPY VARCHAR2
6742: ) IS
6743: appl_short_name VARCHAR2 (30) := 'GME';

Line 6740: x_resource_txns IN OUT NOCOPY gme_resource_txns%ROWTYPE,

6736: -- Sivakumar.G 03-NOV-2005 Created --BUG#4395561
6737: ======================================================================= */
6738: PROCEDURE create_flex_resource_txns (
6739: p_resource_txns IN gme_resource_txns%ROWTYPE,
6740: x_resource_txns IN OUT NOCOPY gme_resource_txns%ROWTYPE,
6741: x_return_status OUT NOCOPY VARCHAR2
6742: ) IS
6743: appl_short_name VARCHAR2 (30) := 'GME';
6744: desc_flex_name VARCHAR2 (30) := 'GME_RSRC_TXN_FLEX';