DBA Data[Home] [Help]

APPS.EGO_PAGES_BULKLOAD_PVT dependencies on DUAL

Line 1922: FROM dual;

1918: lv_smt := 3;
1919: /*Convert transaction type to upper case*/
1920: SELECT Upper(p_pg_tbl(i).transaction_type)
1921: INTO p_pg_tbl(i).transaction_type
1922: FROM dual;
1923: /*check for invalid transaction type for PG*/
1924: IF (p_pg_tbl(i).transaction_type = G_OPR_CREATE
1925: OR p_pg_tbl(i).transaction_type = G_OPR_UPDATE
1926: OR p_pg_tbl(i).transaction_type = G_OPR_DELETE

Line 2049: FROM dual;

2045: lv_smt := 3;
2046: /*Convert transaction type to upper case*/
2047: SELECT Upper(p_ent_tbl(i).transaction_type)
2048: INTO p_ent_tbl(i).transaction_type
2049: FROM dual;
2050: /*check for invalid transaction type for PG*/
2051: IF (p_ent_tbl(i).transaction_type = G_OPR_CREATE
2052: OR p_ent_tbl(i).transaction_type = G_OPR_UPDATE
2053: OR p_ent_tbl(i).transaction_type = G_OPR_DELETE