DBA Data[Home] [Help]

APPS.JL_ZZ_AUTO_INVOICE dependencies on JL_BR_CUSTOMER_TRX_EXTS

Line 1085: l_tow_veh_plate_num2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;

1081: l_country_code VARCHAR2(2);
1082: l_org_id NUMBER;
1083: l_rowid ROWID;
1084: -- BUG 10184720
1085: l_tow_veh_plate_num2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1086: l_tow_veh_plate_state_code2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1087: l_tow_veh_plate_num3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1088: l_tow_veh_plate_state_code3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1089: l_tow_veh_plate_num4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;

Line 1086: l_tow_veh_plate_state_code2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;

1082: l_org_id NUMBER;
1083: l_rowid ROWID;
1084: -- BUG 10184720
1085: l_tow_veh_plate_num2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1086: l_tow_veh_plate_state_code2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1087: l_tow_veh_plate_num3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1088: l_tow_veh_plate_state_code3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1089: l_tow_veh_plate_num4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1090: l_tow_veh_plate_state_code4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;

Line 1087: l_tow_veh_plate_num3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;

1083: l_rowid ROWID;
1084: -- BUG 10184720
1085: l_tow_veh_plate_num2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1086: l_tow_veh_plate_state_code2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1087: l_tow_veh_plate_num3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1088: l_tow_veh_plate_state_code3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1089: l_tow_veh_plate_num4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1090: l_tow_veh_plate_state_code4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1091: l_tow_veh_plate_num5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;

Line 1088: l_tow_veh_plate_state_code3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;

1084: -- BUG 10184720
1085: l_tow_veh_plate_num2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1086: l_tow_veh_plate_state_code2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1087: l_tow_veh_plate_num3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1088: l_tow_veh_plate_state_code3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1089: l_tow_veh_plate_num4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1090: l_tow_veh_plate_state_code4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1091: l_tow_veh_plate_num5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1092: l_tow_veh_plate_state_code5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;

Line 1089: l_tow_veh_plate_num4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;

1085: l_tow_veh_plate_num2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1086: l_tow_veh_plate_state_code2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1087: l_tow_veh_plate_num3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1088: l_tow_veh_plate_state_code3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1089: l_tow_veh_plate_num4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1090: l_tow_veh_plate_state_code4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1091: l_tow_veh_plate_num5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1092: l_tow_veh_plate_state_code5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1093: l_count NUMBER;

Line 1090: l_tow_veh_plate_state_code4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;

1086: l_tow_veh_plate_state_code2 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1087: l_tow_veh_plate_num3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1088: l_tow_veh_plate_state_code3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1089: l_tow_veh_plate_num4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1090: l_tow_veh_plate_state_code4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1091: l_tow_veh_plate_num5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1092: l_tow_veh_plate_state_code5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1093: l_count NUMBER;
1094: l_service_exec_date VARCHAR2(30); -- BUG 11825724

Line 1091: l_tow_veh_plate_num5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;

1087: l_tow_veh_plate_num3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1088: l_tow_veh_plate_state_code3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1089: l_tow_veh_plate_num4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1090: l_tow_veh_plate_state_code4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1091: l_tow_veh_plate_num5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1092: l_tow_veh_plate_state_code5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1093: l_count NUMBER;
1094: l_service_exec_date VARCHAR2(30); -- BUG 11825724
1095: l_so_org_id NUMBER;

Line 1092: l_tow_veh_plate_state_code5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;

1088: l_tow_veh_plate_state_code3 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1089: l_tow_veh_plate_num4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1090: l_tow_veh_plate_state_code4 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1091: l_tow_veh_plate_num5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
1092: l_tow_veh_plate_state_code5 JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
1093: l_count NUMBER;
1094: l_service_exec_date VARCHAR2(30); -- BUG 11825724
1095: l_so_org_id NUMBER;
1096: -- BUG 10184720