1402: * as parameter.
1403: */
1404: SELECT Meaning
1405: INTO l_reject_meaning
1406: FROM PA_Lookups LOOK
1407: WHERE LOOK.Lookup_Type = 'TRANSFER REJECTION CODE'
1408: AND LOOK.Lookup_Code = 'TRANS_INV_DATA';
1409:
1410: FORALL i IN 1..p_local_set_size
1577: )
1578: ,CDL.Transfer_Rejection_Reason =
1579: (
1580: SELECT Meaning
1581: FROM PA_Lookups LOOK
1582: WHERE LOOK.Lookup_Type = 'TRANSFER REJECTION CODE'
1583: AND LOOK.Lookup_Code = Decode(l_interface_to_gl(i),'Y'
1584: ,DECODE(l_gl_date_new(i),NULL,'NO_GL_DATE'
1585: ,DECODE(l_recvr_gl_date_new(i),NULL,'NO_RECVR_GL_DATE',NULL)),NULL)
1644: ,'Y')))
1645: ,CDL.Transfer_Rejection_Reason = -- Bug 3669746
1646: (
1647: SELECT Meaning
1648: FROM PA_Lookups LOOK
1649: WHERE LOOK.Lookup_Type = 'TRANSFER REJECTION CODE'
1650: AND LOOK.Lookup_Code = DECODE(l_gl_date_new(i)
1651: , NULL,'NO_GL_DATE'
1652: ,DECODE(l_recvr_gl_date_new(i)