DBA Data[Home] [Help]

APPS.IGIRRPI dependencies on RA_INTERFACE_SALESCREDITS

Line 54: -- -- Also create a parallel entry in the Ra_interface_salescredits

50: -- Determine Billing Period
51: -- Determine the overall ratio
52: -- Process Price Breaks :
53: -- Create entry in Ra_interface_lines
54: -- -- Also create a parallel entry in the Ra_interface_salescredits
55: -- Build Ra_interface_distribution information in PLSQL table
56: -- Consolidate the amount, percent entries for all the REV distributions in the PLSQL table
57: -- Process Distributions :
58: -- Consolidate the amount, percent entries for all the REC distributions in the PLSQL table

Line 844: FROM ra_interface_salescredits

840:
841: FUNCTION AlreadyExists RETURN BOOLEAN IS
842: CURSOR c_sales IS
843: SELECT 'x'
844: FROM ra_interface_salescredits
845: WHERE
846: pp_rail.interface_line_context = interface_line_context
847: AND pp_rail.interface_line_attribute1 = interface_line_attribute1
848: AND pp_rail.interface_line_attribute2 = interface_line_attribute2

Line 871: INSERT INTO ra_interface_salescredits

867: FOR l_sc in c_salescredits ( pp_sc.salesrep_id ) LOOP
868:
869: IF NOT AlreadyExists THEN
870:
871: INSERT INTO ra_interface_salescredits
872: ( interface_line_context
873: , interface_line_attribute1
874: , interface_line_attribute2
875: , interface_line_attribute3