APPS.GME_INIT_RSRC_TXNS_SUMMARY dependencies on GME_RESOURCE_TXNS

Line 32: gme_resource_txns_summary;

28: CURSOR Get_Rsrc_Txns_Summary IS
29: SELECT
30: COUNT(*)
31: FROM
32: gme_resource_txns_summary;
33:
34: CURSOR Cur_Get_Rsrc_Txns IS
35:
36: SELECT

Line 46: gme_resource_txns

42: sequence_dependent_ind,
43: last_updated_by,
44: last_update_login
45: FROM
46: gme_resource_txns
47: WHERE
48: completed_ind = 0 AND
49: delete_mark = 0;
50:

Line 61: l_resource_id GME_RESOURCE_TXNS_SUMMARY.resource_id%TYPE;

57: WHERE
58: resources = p_resource AND
59: orgn_code = p_orgn_code;
60:
61: l_resource_id GME_RESOURCE_TXNS_SUMMARY.resource_id%TYPE;
62: l_sysdate DATE;
63: l_count NUMBER;
64:
65: BEGIN

Line 96: gme_resource_txns_summary

92: --- First try to update the table by incrementing the number
93: --- of required units.
94:
95: UPDATE
96: gme_resource_txns_summary
97: SET
98: required_units = required_units + 1,
99: last_updated_by = txns_rec.last_updated_by,
100: last_update_date = l_sysdate,

Line 113: INSERT INTO gme_resource_txns_summary

109: IF (SQL%NOTFOUND) THEN
110:
111: --- This new interval does not exist, we need to create it
112:
113: INSERT INTO gme_resource_txns_summary
114: ( resource_id
115: ,instance_id
116: ,start_date
117: ,end_date