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: History
673: 23-SEP-2012 G. Muratore Bug 14637233

Line 677: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

673: 23-SEP-2012 G. Muratore Bug 14637233
674: Comment out unnecessary validation when inserting an activity.
675: =============================================================================================*/
676: PROCEDURE insert_batchstep_activity (
677: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
678: p_batchstep_resource_tbl IN gme_create_step_pvt.resources_tab,
679: p_org_code IN VARCHAR2 := NULL,
680: p_batch_no IN VARCHAR2 := NULL,
681: p_batchstep_no IN NUMBER := NULL,

Line 686: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,

682: p_ignore_qty_below_cap IN VARCHAR2
683: DEFAULT fnd_api.g_false,
684: p_validate_flexfield IN VARCHAR2
685: DEFAULT fnd_api.g_false,
686: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
687: x_return_status OUT NOCOPY VARCHAR2
688: )
689: IS
690: l_api_name CONSTANT VARCHAR2 (30)

Line 698: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;

694: l_activity_id NUMBER;
695: l_batch_status NUMBER;
696: l_step_status NUMBER;
697: l_organization_id PLS_INTEGER;
698: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
699: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;
700: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
701: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;
702: l_prim_rsrc_count NUMBER;

Line 699: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;

695: l_batch_status NUMBER;
696: l_step_status NUMBER;
697: l_organization_id PLS_INTEGER;
698: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
699: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;
700: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
701: l_batchstep_resource_out_rec gme_batch_step_resources%ROWTYPE;
702: l_prim_rsrc_count NUMBER;
703: l_rsrc_id PLS_INTEGER;

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

900: gme_debug.put_line ( g_pkg_name
901: || '.'
902: || l_api_name
903: || ':'
904: || 'before call to GME_BATCH_STEP_ACTIVITIES_DBL.insert_row batch_id='
905: || l_batchstep_activity_rec.batch_id
906: || ' and step_id ='
907: || l_batchstep_activity_rec.batchstep_id
908: );

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

907: || l_batchstep_activity_rec.batchstep_id
908: );
909: END IF;
910:
911: IF NOT (gme_batch_step_activities_dbl.insert_row (l_batchstep_activity_rec,
912: l_batchstep_activity_out_rec
913: )
914: )
915: THEN

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

921: gme_debug.put_line ( g_pkg_name
922: || '.'
923: || l_api_name
924: || ':'
925: || 'after call to GME_BATCH_STEP_ACTIVITIES_DBL.insert_row activity_id='
926: || l_batchstep_activity_out_rec.batchstep_activity_id
927: );
928: END IF;
929:

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

1012: This procedure is used to update an activity
1013: Parameters
1014: p_batchstep_activity_id OR
1015: (p_org_code,p_batch_no,step_no,activity) to uniquely identify an activity
1016: p_batchstep_activity_rec GME_BATCH_STEP_ACTIVITIES%ROWTYPE - details of the activity
1017: x_batchstep_activity_rec returns the newly updated row for further processing
1018: x_return_status reflects return status of the API
1019: History
1020: =============================================================================================*/

Line 1022: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

1018: x_return_status reflects return status of the API
1019: History
1020: =============================================================================================*/
1021: PROCEDURE update_batchstep_activity (
1022: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
1023: p_org_code IN VARCHAR2 := NULL,
1024: p_batch_no IN VARCHAR2 := NULL,
1025: p_batchstep_no IN NUMBER := NULL,
1026: p_validate_flexfield IN VARCHAR2

Line 1028: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,

1024: p_batch_no IN VARCHAR2 := NULL,
1025: p_batchstep_no IN NUMBER := NULL,
1026: p_validate_flexfield IN VARCHAR2
1027: DEFAULT fnd_api.g_false,
1028: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
1029: x_return_status OUT NOCOPY VARCHAR2
1030: )
1031: IS
1032: l_api_name CONSTANT VARCHAR2 (30)

Line 1036: l_activity gme_batch_step_activities.activity%TYPE;

1032: l_api_name CONSTANT VARCHAR2 (30)
1033: := 'update_batchstep_activity';
1034: l_batch_id NUMBER;
1035: l_activity_id NUMBER;
1036: l_activity gme_batch_step_activities.activity%TYPE;
1037: l_batchstep_id NUMBER;
1038: l_batch_status NUMBER;
1039: l_step_status NUMBER;
1040: l_batch_type NUMBER;

Line 1047: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;

1043: l_upd_act_date BOOLEAN := FALSE;
1044: l_update_resources BOOLEAN := FALSE;
1045: l_flex_validate BOOLEAN := FALSE;
1046: l_last_update_date DATE;
1047: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1048: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;
1049: --Bug 3027004 Mohit Kapoor Added two variables
1050: l_inv_trans_count NUMBER;
1051: l_rsrc_trans_count NUMBER;

Line 1048: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;

1044: l_update_resources BOOLEAN := FALSE;
1045: l_flex_validate BOOLEAN := FALSE;
1046: l_last_update_date DATE;
1047: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1048: l_batchstep_activity_out_rec gme_batch_step_activities%ROWTYPE;
1049: --Bug 3027004 Mohit Kapoor Added two variables
1050: l_inv_trans_count NUMBER;
1051: l_rsrc_trans_count NUMBER;
1052:

Line 1067: FROM gme_batch_step_activities a, gme_batch_steps s

1063:
1064: CURSOR cur_get_dtl (v_act_id NUMBER)
1065: IS
1066: SELECT a.batch_id, a.batchstep_id, step_status, activity
1067: FROM gme_batch_step_activities a, gme_batch_steps s
1068: WHERE batchstep_activity_id = v_act_id
1069: AND a.batchstep_id = s.batchstep_id;
1070:
1071: CURSOR cur_get_step_dtl (v_step_id NUMBER)

Line 1090: FROM gme_batch_header b, gme_batch_step_activities a

1086:
1087: CURSOR cur_check_fpo (v_actv_id NUMBER)
1088: IS
1089: SELECT batch_type
1090: FROM gme_batch_header b, gme_batch_step_activities a
1091: WHERE b.batch_id = a.batch_id AND batchstep_activity_id = v_actv_id;
1092:
1093: CURSOR cur_lock_actv (v_activity_id NUMBER)
1094: IS

Line 1096: FROM gme_batch_step_activities

1092:
1093: CURSOR cur_lock_actv (v_activity_id NUMBER)
1094: IS
1095: SELECT last_update_date
1096: FROM gme_batch_step_activities
1097: WHERE batchstep_activity_id = v_activity_id
1098: FOR UPDATE OF last_update_date NOWAIT;
1099:
1100: l_seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE;

Line 1100: l_seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE;

1096: FROM gme_batch_step_activities
1097: WHERE batchstep_activity_id = v_activity_id
1098: FOR UPDATE OF last_update_date NOWAIT;
1099:
1100: l_seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE;
1101: BEGIN
1102: IF (NVL (g_debug, 0) IN
1103: (gme_debug.g_log_statement, gme_debug.g_log_procedure)
1104: )

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

1193: THEN
1194: gme_debug.put_line (' Successfully locked the activity');
1195: END IF;
1196:
1197: IF NOT (gme_batch_step_activities_dbl.fetch_row (p_batchstep_activity_rec,
1198: l_batchstep_activity_rec
1199: )
1200: )
1201: THEN

Line 1721: IF NOT (gme_batch_step_activities_dbl.update_row (l_batchstep_activity_rec

1717: RAISE fnd_api.g_exc_unexpected_error;
1718: END IF;
1719: END IF;
1720:
1721: IF NOT (gme_batch_step_activities_dbl.update_row (l_batchstep_activity_rec
1722: )
1723: )
1724: THEN
1725: RAISE fnd_api.g_exc_error;

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

1731: );
1732: END IF;
1733:
1734: /*Fetching the values from the db again to get the latest seq_dep_ind.*/
1735: IF NOT (gme_batch_step_activities_dbl.fetch_row (l_batchstep_activity_rec,
1736: l_batchstep_activity_rec
1737: )
1738: )
1739: THEN

Line 1762: 'GME_BATCH_STEP_ACTIVITIES',

1758: WHEN app_exception.record_lock_exception
1759: THEN
1760: gme_common_pvt.log_message ('GME_RECORD_LOCKED',
1761: 'TABLE_NAME',
1762: 'GME_BATCH_STEP_ACTIVITIES',
1763: 'RECORD',
1764: 'Activity',
1765: 'KEY',
1766: l_activity

Line 1830: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;

1826: l_batch_type NUMBER;
1827: l_activity_id NUMBER;
1828: l_batch_id NUMBER;
1829: l_batchstep_id NUMBER;
1830: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1831: x_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1832: l_cnt NUMBER;
1833: l_activity gme_batch_step_activities.activity%TYPE;
1834: l_last_update_date DATE;

Line 1831: x_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;

1827: l_activity_id NUMBER;
1828: l_batch_id NUMBER;
1829: l_batchstep_id NUMBER;
1830: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1831: x_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1832: l_cnt NUMBER;
1833: l_activity gme_batch_step_activities.activity%TYPE;
1834: l_last_update_date DATE;
1835: l_inv_trans_count NUMBER;

Line 1833: l_activity gme_batch_step_activities.activity%TYPE;

1829: l_batchstep_id NUMBER;
1830: l_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1831: x_batchstep_activity_rec gme_batch_step_activities%ROWTYPE;
1832: l_cnt NUMBER;
1833: l_activity gme_batch_step_activities.activity%TYPE;
1834: l_last_update_date DATE;
1835: l_inv_trans_count NUMBER;
1836: l_rsrc_trans_count NUMBER;
1837: l_batch_hdr gme_batch_header%ROWTYPE;

Line 1850: gme_batch_step_activities a,

1846: IS
1847: SELECT step_status, batch_status, a.batch_id, s.batchstep_id,
1848: batchstep_activity_id, activity
1849: FROM gme_batch_steps s,
1850: gme_batch_step_activities a,
1851: gme_batch_header b
1852: WHERE batchstep_activity_id = v_batchstep_act_id
1853: AND b.batch_id = a.batch_id
1854: AND s.batchstep_id = a.batchstep_id;

Line 1859: FROM gme_batch_step_activities

1855:
1856: CURSOR cur_get_activity_count (v_step_id NUMBER)
1857: IS
1858: SELECT COUNT (1)
1859: FROM gme_batch_step_activities
1860: WHERE batchstep_id = v_step_id;
1861:
1862: CURSOR cur_check_fpo (v_actv_id NUMBER)
1863: IS

Line 1865: FROM gme_batch_header b, gme_batch_step_activities a

1861:
1862: CURSOR cur_check_fpo (v_actv_id NUMBER)
1863: IS
1864: SELECT batch_type
1865: FROM gme_batch_header b, gme_batch_step_activities a
1866: WHERE b.batch_id = a.batch_id AND batchstep_activity_id = v_actv_id;
1867:
1868: CURSOR cur_lock_actv (v_activity_id NUMBER)
1869: IS

Line 1871: FROM gme_batch_step_activities

1867:
1868: CURSOR cur_lock_actv (v_activity_id NUMBER)
1869: IS
1870: SELECT last_update_date
1871: FROM gme_batch_step_activities
1872: WHERE batchstep_activity_id = v_activity_id
1873: FOR UPDATE OF last_update_date NOWAIT;
1874: BEGIN
1875: IF (NVL (g_debug, 0) IN

Line 2057: 'GME_BATCH_STEP_ACTIVITIES',

2053: WHEN app_exception.record_lock_exception
2054: THEN
2055: gme_common_pvt.log_message ('GME_RECORD_LOCKED',
2056: 'TABLE_NAME',
2057: 'GME_BATCH_STEP_ACTIVITIES',
2058: 'RECORD',
2059: 'Activity',
2060: 'KEY',
2061: l_activity