APPS.GME_TEXT_DBL dependencies on GME_COMMON_PVT

Line 16: VALUES (gem5_text_code_s.NEXTVAL, gme_common_pvt.g_user_ident

12: INSERT INTO gme_text_header
13: (text_code, created_by
14: ,creation_date, last_updated_by
15: ,last_update_date)
16: VALUES (gem5_text_code_s.NEXTVAL, gme_common_pvt.g_user_ident
17: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
18: ,gme_common_pvt.g_timestamp)
19: RETURNING text_code
20: INTO x_header.text_code;

Line 17: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

13: (text_code, created_by
14: ,creation_date, last_updated_by
15: ,last_update_date)
16: VALUES (gem5_text_code_s.NEXTVAL, gme_common_pvt.g_user_ident
17: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
18: ,gme_common_pvt.g_timestamp)
19: RETURNING text_code
20: INTO x_header.text_code;
21:

Line 18: ,gme_common_pvt.g_timestamp)

14: ,creation_date, last_updated_by
15: ,last_update_date)
16: VALUES (gem5_text_code_s.NEXTVAL, gme_common_pvt.g_user_ident
17: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
18: ,gme_common_pvt.g_timestamp)
19: RETURNING text_code
20: INTO x_header.text_code;
21:
22: RETURN TRUE;

Line 46: ,x_creation_date => gme_common_pvt.g_timestamp

42: ,x_paragraph_code => p_text_row.paragraph_code
43: ,x_sub_paracode => p_text_row.sub_paracode
44: ,x_line_no => p_text_row.line_no
45: ,x_text => p_text_row.text
46: ,x_creation_date => gme_common_pvt.g_timestamp
47: ,x_created_by => gme_common_pvt.g_user_ident
48: ,x_last_updated_by => gme_common_pvt.g_user_ident
49: ,x_last_update_date => gme_common_pvt.g_timestamp
50: ,x_last_update_login => gme_common_pvt.g_login_id);

Line 47: ,x_created_by => gme_common_pvt.g_user_ident

43: ,x_sub_paracode => p_text_row.sub_paracode
44: ,x_line_no => p_text_row.line_no
45: ,x_text => p_text_row.text
46: ,x_creation_date => gme_common_pvt.g_timestamp
47: ,x_created_by => gme_common_pvt.g_user_ident
48: ,x_last_updated_by => gme_common_pvt.g_user_ident
49: ,x_last_update_date => gme_common_pvt.g_timestamp
50: ,x_last_update_login => gme_common_pvt.g_login_id);
51: RETURN TRUE;

Line 48: ,x_last_updated_by => gme_common_pvt.g_user_ident

44: ,x_line_no => p_text_row.line_no
45: ,x_text => p_text_row.text
46: ,x_creation_date => gme_common_pvt.g_timestamp
47: ,x_created_by => gme_common_pvt.g_user_ident
48: ,x_last_updated_by => gme_common_pvt.g_user_ident
49: ,x_last_update_date => gme_common_pvt.g_timestamp
50: ,x_last_update_login => gme_common_pvt.g_login_id);
51: RETURN TRUE;
52: EXCEPTION

Line 49: ,x_last_update_date => gme_common_pvt.g_timestamp

45: ,x_text => p_text_row.text
46: ,x_creation_date => gme_common_pvt.g_timestamp
47: ,x_created_by => gme_common_pvt.g_user_ident
48: ,x_last_updated_by => gme_common_pvt.g_user_ident
49: ,x_last_update_date => gme_common_pvt.g_timestamp
50: ,x_last_update_login => gme_common_pvt.g_login_id);
51: RETURN TRUE;
52: EXCEPTION
53: WHEN OTHERS THEN

Line 50: ,x_last_update_login => gme_common_pvt.g_login_id);

46: ,x_creation_date => gme_common_pvt.g_timestamp
47: ,x_created_by => gme_common_pvt.g_user_ident
48: ,x_last_updated_by => gme_common_pvt.g_user_ident
49: ,x_last_update_date => gme_common_pvt.g_timestamp
50: ,x_last_update_login => gme_common_pvt.g_login_id);
51: RETURN TRUE;
52: EXCEPTION
53: WHEN OTHERS THEN
54: --Bug2804440