eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_BATCHSTEP_ACT_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 52: FROM gme_batch_step_activities

48: v_batch_id NUMBER
49: )
50: IS
51: SELECT batchstep_activity_id
52: FROM gme_batch_step_activities
53: WHERE batchstep_id = v_step_id
54: AND batch_id = v_batch_id
55: AND activity = v_activity;
56: BEGIN

Line 195: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

191:
192: x_return_status reflects return status of the API
193: =============================================================================================*/
194: PROCEDURE validate_activity_param (
195: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
196: p_step_id IN NUMBER,
197: p_validate_flexfield IN VARCHAR2
198: DEFAULT fnd_api.g_false,
199: p_action IN VARCHAR2,

Line 200: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,

196: p_step_id IN NUMBER,
197: p_validate_flexfield IN VARCHAR2
198: DEFAULT fnd_api.g_false,
199: p_action IN VARCHAR2,
200: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
201: x_step_status OUT NOCOPY NUMBER,
202: x_return_status OUT NOCOPY VARCHAR2
203: )
204: IS

Line 207: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;

203: )
204: IS
205: l_api_name CONSTANT VARCHAR2 (30) := 'validate_activity_param';
206: l_batch_asqc NUMBER;
207: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
208: l_step_dtl gme_batch_steps%ROWTYPE;
209: l_dummy NUMBER;
210: l_activity_factor NUMBER;
211: l_batch_type NUMBER;

Line 667: p_batchstep_activity_rec GME_BATCH_STEP_ACTIVITIES%ROWTYPE - details of the activity

663: Description
664: This procedure is used to insert activity for a batch step
665: Parameters
666: p_batchstep_id OR (p_org_code,p_batch_no,step_no) to uniquely identify a step
667: p_batchstep_activity_rec GME_BATCH_STEP_ACTIVITIES%ROWTYPE - details of the activity
668: p_batchstep_resource_tbl gme_create_step_pvt.resources_tab - details of the rsrc
669: x_batchstep_activity_rec GME_BATCH_STEP_ACTIVITIES%ROWTYPE - returns the newly inserted row
670: x_return_status reflects return status of the API
671: =============================================================================================*/

Line 669: x_batchstep_activity_rec GME_BATCH_STEP_ACTIVITIES%ROWTYPE - returns the newly inserted row

665: Parameters
666: p_batchstep_id OR (p_org_code,p_batch_no,step_no) to uniquely identify a step
667: p_batchstep_activity_rec GME_BATCH_STEP_ACTIVITIES%ROWTYPE - details of the activity
668: p_batchstep_resource_tbl gme_create_step_pvt.resources_tab - details of the rsrc
669: x_batchstep_activity_rec GME_BATCH_STEP_ACTIVITIES%ROWTYPE - returns the newly inserted row
670: x_return_status reflects return status of the API
671: =============================================================================================*/
672: PROCEDURE insert_batchstep_activity (
673: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

Line 673: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

669: x_batchstep_activity_rec GME_BATCH_STEP_ACTIVITIES%ROWTYPE - returns the newly inserted row
670: x_return_status reflects return status of the API
671: =============================================================================================*/
672: PROCEDURE insert_batchstep_activity (
673: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
674: p_batchstep_resource_tbl IN gme_create_step_pvt.resources_tab,
675: p_org_code IN VARCHAR2 := NULL,
676: p_batch_no IN VARCHAR2 := NULL,
677: p_batchstep_no IN NUMBER := NULL,

Line 682: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,

678: p_ignore_qty_below_cap IN VARCHAR2
679: DEFAULT fnd_api.g_false,
680: p_validate_flexfield IN VARCHAR2
681: DEFAULT fnd_api.g_false,
682: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
683: x_return_status OUT NOCOPY VARCHAR2
684: )
685: IS
686: l_api_name CONSTANT VARCHAR2 (30)

Line 694: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;

690: l_activity_id NUMBER;
691: l_batch_status NUMBER;
692: l_step_status NUMBER;
693: l_organization_id PLS_INTEGER;
694: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
695: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;
696: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
697: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;
698: l_prim_rsrc_count NUMBER;

Line 695: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;

691: l_batch_status NUMBER;
692: l_step_status NUMBER;
693: l_organization_id PLS_INTEGER;
694: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
695: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;
696: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
697: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;
698: l_prim_rsrc_count NUMBER;
699: l_rsrc_id PLS_INTEGER;

Line 897: || 'before call to GME_BATCH_STEP_ACTIVITIES_DBL.insert_row batch_id='

893: gme_debug.put_line ( g_pkg_name
894: || '.'
895: || l_api_name
896: || ':'
897: || 'before call to GME_BATCH_STEP_ACTIVITIES_DBL.insert_row batch_id='
898: || l_batchstep_activity_rec.batch_id
899: || ' and step_id ='
900: || l_batchstep_activity_rec.batchstep_id
901: );

Line 904: IF NOT (gme_batch_step_activities_dbl.insert_row (l_batchstep_activity_rec,

900: || l_batchstep_activity_rec.batchstep_id
901: );
902: END IF;
903:
904: IF NOT (gme_batch_step_activities_dbl.insert_row (l_batchstep_activity_rec,
905: l_batchstep_activity_out_rec
906: )
907: )
908: THEN

Line 918: || 'after call to GME_BATCH_STEP_ACTIVITIES_DBL.insert_row activity_id='

914: gme_debug.put_line ( g_pkg_name
915: || '.'
916: || l_api_name
917: || ':'
918: || 'after call to GME_BATCH_STEP_ACTIVITIES_DBL.insert_row activity_id='
919: || l_batchstep_activity_out_rec.batchstep_activity_id
920: );
921: END IF;
922:

Line 1009: p_batchstep_activity_rec GME_BATCH_STEP_ACTIVITIES%ROWTYPE - details of the activity

1005: This procedure is used to update an activity
1006: Parameters
1007: p_batchstep_activity_id OR
1008: (p_org_code,p_batch_no,step_no,activity) to uniquely identify an activity
1009: p_batchstep_activity_rec GME_BATCH_STEP_ACTIVITIES%ROWTYPE - details of the activity
1010: x_batchstep_activity_rec returns the newly updated row for further processing
1011: x_return_status reflects return status of the API
1012: History
1013: =============================================================================================*/

Line 1015: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

1011: x_return_status reflects return status of the API
1012: History
1013: =============================================================================================*/
1014: PROCEDURE update_batchstep_activity (
1015: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
1016: p_org_code IN VARCHAR2 := NULL,
1017: p_batch_no IN VARCHAR2 := NULL,
1018: p_batchstep_no IN NUMBER := NULL,
1019: p_validate_flexfield IN VARCHAR2

Line 1021: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,

1017: p_batch_no IN VARCHAR2 := NULL,
1018: p_batchstep_no IN NUMBER := NULL,
1019: p_validate_flexfield IN VARCHAR2
1020: DEFAULT fnd_api.g_false,
1021: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
1022: x_return_status OUT NOCOPY VARCHAR2
1023: )
1024: IS
1025: l_api_name CONSTANT VARCHAR2 (30)

Line 1029: l_activity gme_batch_step_activities.activity%TYPE;

1025: l_api_name CONSTANT VARCHAR2 (30)
1026: := 'update_batchstep_activity';
1027: l_batch_id NUMBER;
1028: l_activity_id NUMBER;
1029: l_activity gme_batch_step_activities.activity%TYPE;
1030: l_batchstep_id NUMBER;
1031: l_batch_status NUMBER;
1032: l_step_status NUMBER;
1033: l_batch_type NUMBER;

Line 1040: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;

1036: l_upd_act_date BOOLEAN := FALSE;
1037: l_update_resources BOOLEAN := FALSE;
1038: l_flex_validate BOOLEAN := FALSE;
1039: l_last_update_date DATE;
1040: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1041: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;
1042: --Bug 3027004 Mohit Kapoor Added two variables
1043: l_inv_trans_count NUMBER;
1044: l_rsrc_trans_count NUMBER;

Line 1041: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;

1037: l_update_resources BOOLEAN := FALSE;
1038: l_flex_validate BOOLEAN := FALSE;
1039: l_last_update_date DATE;
1040: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1041: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;
1042: --Bug 3027004 Mohit Kapoor Added two variables
1043: l_inv_trans_count NUMBER;
1044: l_rsrc_trans_count NUMBER;
1045:

Line 1060: FROM gme_batch_step_activities a, gme_batch_steps s

1056:
1057: CURSOR cur_get_dtl (v_act_id NUMBER)
1058: IS
1059: SELECT a.batch_id, a.batchstep_id, step_status, activity
1060: FROM gme_batch_step_activities a, gme_batch_steps s
1061: WHERE batchstep_activity_id = v_act_id
1062: AND a.batchstep_id = s.batchstep_id;
1063:
1064: CURSOR cur_get_step_dtl (v_step_id NUMBER)

Line 1083: FROM gme_batch_header b, gme_batch_step_activities a

1079:
1080: CURSOR cur_check_fpo (v_actv_id NUMBER)
1081: IS
1082: SELECT batch_type
1083: FROM gme_batch_header b, gme_batch_step_activities a
1084: WHERE b.batch_id = a.batch_id AND batchstep_activity_id = v_actv_id;
1085:
1086: CURSOR cur_lock_actv (v_activity_id NUMBER)
1087: IS

Line 1089: FROM gme_batch_step_activities

1085:
1086: CURSOR cur_lock_actv (v_activity_id NUMBER)
1087: IS
1088: SELECT last_update_date
1089: FROM gme_batch_step_activities
1090: WHERE batchstep_activity_id = v_activity_id
1091: FOR UPDATE OF last_update_date NOWAIT;
1092:
1093: l_seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE;

Line 1093: l_seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE;

1089: FROM gme_batch_step_activities
1090: WHERE batchstep_activity_id = v_activity_id
1091: FOR UPDATE OF last_update_date NOWAIT;
1092:
1093: l_seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE;
1094: BEGIN
1095: IF (NVL (g_debug, 0) IN
1096: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
1097: )

Line 1190: IF NOT (gme_batch_step_activities_dbl.fetch_row (p_batchstep_activity_rec,

1186: THEN
1187: gme_debug.put_line (' Successfully locked the activity');
1188: END IF;
1189:
1190: IF NOT (gme_batch_step_activities_dbl.fetch_row (p_batchstep_activity_rec,
1191: l_batchstep_activity_rec
1192: )
1193: )
1194: THEN

Line 1714: IF NOT (gme_batch_step_activities_dbl.update_row (l_batchstep_activity_rec

1710: RAISE fnd_api.g_exc_unexpected_error;
1711: END IF;
1712: END IF;
1713:
1714: IF NOT (gme_batch_step_activities_dbl.update_row (l_batchstep_activity_rec
1715: )
1716: )
1717: THEN
1718: RAISE fnd_api.g_exc_error;

Line 1728: IF NOT (gme_batch_step_activities_dbl.fetch_row (l_batchstep_activity_rec,

1724: );
1725: END IF;
1726:
1727: /*Fetching the values from the db again to get the latest seq_dep_ind.*/
1728: IF NOT (gme_batch_step_activities_dbl.fetch_row (l_batchstep_activity_rec,
1729: l_batchstep_activity_rec
1730: )
1731: )
1732: THEN

Line 1755: 'GME_BATCH_STEP_ACTIVITIES',

1751: WHEN app_exception.record_lock_exception
1752: THEN
1753: gme_common_pvt.log_message ('GME_RECORD_LOCKED',
1754: 'TABLE_NAME',
1755: 'GME_BATCH_STEP_ACTIVITIES',
1756: 'RECORD',
1757: 'Activity',
1758: 'KEY',
1759: l_activity

Line 1823: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;

1819: l_batch_type NUMBER;
1820: l_activity_id NUMBER;
1821: l_batch_id NUMBER;
1822: l_batchstep_id NUMBER;
1823: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1824: x_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1825: l_cnt NUMBER;
1826: l_activity gme_batch_step_activities.activity%TYPE;
1827: l_last_update_date DATE;

Line 1824: x_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;

1820: l_activity_id NUMBER;
1821: l_batch_id NUMBER;
1822: l_batchstep_id NUMBER;
1823: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1824: x_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1825: l_cnt NUMBER;
1826: l_activity gme_batch_step_activities.activity%TYPE;
1827: l_last_update_date DATE;
1828: l_inv_trans_count NUMBER;

Line 1826: l_activity gme_batch_step_activities.activity%TYPE;

1822: l_batchstep_id NUMBER;
1823: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1824: x_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1825: l_cnt NUMBER;
1826: l_activity gme_batch_step_activities.activity%TYPE;
1827: l_last_update_date DATE;
1828: l_inv_trans_count NUMBER;
1829: l_rsrc_trans_count NUMBER;
1830: l_batch_hdr gme_batch_header%ROWTYPE;

Line 1843: gme_batch_step_activities a,

1839: IS
1840: SELECT step_status, batch_status, a.batch_id, s.batchstep_id,
1841: batchstep_activity_id, activity
1842: FROM gme_batch_steps s,
1843: gme_batch_step_activities a,
1844: gme_batch_header b
1845: WHERE batchstep_activity_id = v_batchstep_act_id
1846: AND b.batch_id = a.batch_id
1847: AND s.batchstep_id = a.batchstep_id;

Line 1852: FROM gme_batch_step_activities

1848:
1849: CURSOR cur_get_activity_count (v_step_id NUMBER)
1850: IS
1851: SELECT COUNT (1)
1852: FROM gme_batch_step_activities
1853: WHERE batchstep_id = v_step_id;
1854:
1855: CURSOR cur_check_fpo (v_actv_id NUMBER)
1856: IS

Line 1858: FROM gme_batch_header b, gme_batch_step_activities a

1854:
1855: CURSOR cur_check_fpo (v_actv_id NUMBER)
1856: IS
1857: SELECT batch_type
1858: FROM gme_batch_header b, gme_batch_step_activities a
1859: WHERE b.batch_id = a.batch_id AND batchstep_activity_id = v_actv_id;
1860:
1861: CURSOR cur_lock_actv (v_activity_id NUMBER)
1862: IS

Line 1864: FROM gme_batch_step_activities

1860:
1861: CURSOR cur_lock_actv (v_activity_id NUMBER)
1862: IS
1863: SELECT last_update_date
1864: FROM gme_batch_step_activities
1865: WHERE batchstep_activity_id = v_activity_id
1866: FOR UPDATE OF last_update_date NOWAIT;
1867: BEGIN
1868: IF (NVL (g_debug, 0) IN

Line 2050: 'GME_BATCH_STEP_ACTIVITIES',

2046: WHEN app_exception.record_lock_exception
2047: THEN
2048: gme_common_pvt.log_message ('GME_RECORD_LOCKED',
2049: 'TABLE_NAME',
2050: 'GME_BATCH_STEP_ACTIVITIES',
2051: 'RECORD',
2052: 'Activity',
2053: 'KEY',
2054: l_activity