APPS.OZF_SD_BATCH_PUB dependencies on FND_GLOBAL

Line 97: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),

93: UPDATE ozf_sd_batch_headers_all
94: SET status_code = 'SUBMITTED',
95: object_version_number = object_version_number + 1,
96: batch_submission_date = SYSDATE,
97: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
98: last_update_date = SYSDATE,
99: last_updated_by = NVL(FND_GLOBAL.user_id,-1)
100: WHERE batch_id = p_batch_id;
101: END IF;

Line 99: last_updated_by = NVL(FND_GLOBAL.user_id,-1)

95: object_version_number = object_version_number + 1,
96: batch_submission_date = SYSDATE,
97: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
98: last_update_date = SYSDATE,
99: last_updated_by = NVL(FND_GLOBAL.user_id,-1)
100: WHERE batch_id = p_batch_id;
101: END IF;
102:
103: IF l_status = 'WIP' THEN

Line 107: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),

103: IF l_status = 'WIP' THEN
104: UPDATE ozf_sd_batch_line_disputes
105: SET object_version_number = object_version_number + 1,
106: review_flag = 'Y',
107: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
108: last_update_date = SYSDATE,
109: last_updated_by = NVL(FND_GLOBAL.user_id,-1)
110: WHERE batch_id = p_batch_id
111: AND batch_line_id IN ( SELECT batch_line_id

Line 109: last_updated_by = NVL(FND_GLOBAL.user_id,-1)

105: SET object_version_number = object_version_number + 1,
106: review_flag = 'Y',
107: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
108: last_update_date = SYSDATE,
109: last_updated_by = NVL(FND_GLOBAL.user_id,-1)
110: WHERE batch_id = p_batch_id
111: AND batch_line_id IN ( SELECT batch_line_id
112: FROM ozf_sd_batch_lines_all
113: WHERE batch_id = p_batch_id

Line 124: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),

120: object_version_number = object_version_number + 1,
121: transmit_flag = 'N',
122: process_feed_flag = 'Y',
123: last_sub_claim_amount = batch_curr_claim_amount,
124: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
125: last_update_date = SYSDATE,
126: last_updated_by = NVL(FND_GLOBAL.user_id,-1)
127: WHERE batch_id = p_batch_id
128: AND purge_flag <> 'Y'

Line 126: last_updated_by = NVL(FND_GLOBAL.user_id,-1)

122: process_feed_flag = 'Y',
123: last_sub_claim_amount = batch_curr_claim_amount,
124: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
125: last_update_date = SYSDATE,
126: last_updated_by = NVL(FND_GLOBAL.user_id,-1)
127: WHERE batch_id = p_batch_id
128: AND purge_flag <> 'Y'
129: AND transmit_flag = 'Y';
130: