eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_ADVERTISEMENTS_PUB

Line 350: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

346: l_action_line_audit_rec.action_code := p_action_code;
347: l_action_line_audit_rec.audit_display_attribute := NULL;
348: l_action_line_audit_rec.audit_attribute := NULL;
349: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
350: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
351: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
352:
353: END IF;
354: -- 4537865 : Included Exception Block

Line 351: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

347: l_action_line_audit_rec.audit_display_attribute := NULL;
348: l_action_line_audit_rec.audit_attribute := NULL;
349: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
350: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
351: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
352:
353: END IF;
354: -- 4537865 : Included Exception Block
355: EXCEPTION

Line 460: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

456: l_action_line_audit_rec.action_code := p_action_code;
457: l_action_line_audit_rec.audit_display_attribute := l_organization_name_tbl(i);
458: l_action_line_audit_rec.audit_attribute := l_organization_id_tbl(i);
459: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
460: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
461: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
462: END LOOP;
463:
464: --dbms_output.put_line('number of records in audit global tbl: '||PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT);

Line 461: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

457: l_action_line_audit_rec.audit_display_attribute := l_organization_name_tbl(i);
458: l_action_line_audit_rec.audit_attribute := l_organization_id_tbl(i);
459: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
460: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
461: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
462: END LOOP;
463:
464: --dbms_output.put_line('number of records in audit global tbl: '||PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT);
465:

Line 464: --dbms_output.put_line('number of records in audit global tbl: '||PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT);

460: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
461: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
462: END LOOP;
463:
464: --dbms_output.put_line('number of records in audit global tbl: '||PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT);
465:
466: END IF; -- l_organization_id_tbl.count = 0
467:
468: -- Insert the error into the audit table

Line 481: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

477:
478: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
479: l_action_line_audit_rec.action_code := p_action_code;
480: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
481: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
482: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
483: END IF;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: END IF; -- IF FND_MSG_PUB.Count_Msg > 0

Line 482: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

478: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
479: l_action_line_audit_rec.action_code := p_action_code;
480: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
481: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
482: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
483: END IF;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: END IF; -- IF FND_MSG_PUB.Count_Msg > 0
486:

Line 672: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

668: l_action_line_audit_rec.action_code := p_action_code;
669: l_action_line_audit_rec.audit_display_attribute := l_organization_name_tbl(i);
670: l_action_line_audit_rec.audit_attribute := l_organization_id_tbl(i);
671: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
672: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
673: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
674: END LOOP;
675:
676: END IF; -- if l_organization_id_tbl.COUNT = 0

Line 673: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

669: l_action_line_audit_rec.audit_display_attribute := l_organization_name_tbl(i);
670: l_action_line_audit_rec.audit_attribute := l_organization_id_tbl(i);
671: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
672: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
673: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
674: END LOOP;
675:
676: END IF; -- if l_organization_id_tbl.COUNT = 0
677: END IF; --if l_new_start_org_id is null

Line 695: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

691:
692: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
693: l_action_line_audit_rec.action_code := p_action_code;
694: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
695: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
696: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
697: END IF;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: END IF;

Line 696: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

692: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
693: l_action_line_audit_rec.action_code := p_action_code;
694: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
695: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
696: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
697: END IF;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: END IF;
700:

Line 811: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

807: l_action_line_audit_rec.action_code := p_action_code;
808: l_action_line_audit_rec.audit_display_attribute := l_person_name_tbl(i);
809: l_action_line_audit_rec.audit_attribute := l_person_id_tbl(i);
810: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
811: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
812: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
813: END LOOP;
814:
815: END IF; -- if l_person_id_tbl.COUNT = 0

Line 812: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

808: l_action_line_audit_rec.audit_display_attribute := l_person_name_tbl(i);
809: l_action_line_audit_rec.audit_attribute := l_person_id_tbl(i);
810: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
811: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
812: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
813: END LOOP;
814:
815: END IF; -- if l_person_id_tbl.COUNT = 0
816:

Line 832: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

828:
829: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
830: l_action_line_audit_rec.action_code := p_action_code;
831: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
832: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
833: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
834: END IF;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: END IF;

Line 833: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

829: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
830: l_action_line_audit_rec.action_code := p_action_code;
831: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
832: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
833: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
834: END IF;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: END IF;
837:

Line 967: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

963: l_action_line_audit_rec.audit_display_attribute := l_email_tab(j);--p_email_address added for 4701745;
964: l_action_line_audit_rec.audit_attribute := l_email_tab(j);--p_email_address added for 4701745;
965: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
966:
967: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
968: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
969:
970: END IF;
971:

Line 968: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

964: l_action_line_audit_rec.audit_attribute := l_email_tab(j);--p_email_address added for 4701745;
965: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
966:
967: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
968: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
969:
970: END IF;
971:
972: END IF; -- l_email_tab(j) NOT NULL - added for 4701745

Line 1168: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1164: l_action_line_audit_rec.reason_code := 'UPDATED';
1165: ELSE
1166: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
1167: END IF;
1168: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1169: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1170: END LOOP;
1171: END IF;
1172: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1169: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1165: ELSE
1166: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
1167: END IF;
1168: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1169: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1170: END LOOP;
1171: END IF;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: END IF;

Line 1596: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1592: l_action_line_audit_rec.audit_display_attribute := p_ntf_recipient_name_tbl(i);
1593: l_action_line_audit_rec.audit_attribute := l_ntf_recipient_person_id_tbl(i);
1594: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1595:
1596: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1597: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1598:
1599: END IF;
1600:

Line 1597: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1593: l_action_line_audit_rec.audit_attribute := l_ntf_recipient_person_id_tbl(i);
1594: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1595:
1596: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1597: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1598:
1599: END IF;
1600:
1601: END IF; --if username is null

Line 1685: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1681: l_action_line_audit_rec.action_code := p_action_code;
1682: l_action_line_audit_rec.audit_display_attribute := l_staffing_priority_name;
1683: l_action_line_audit_rec.audit_attribute := p_staffing_priority_code;
1684: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1685: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1686: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1687:
1688: ELSE
1689:

Line 1686: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1682: l_action_line_audit_rec.audit_display_attribute := l_staffing_priority_name;
1683: l_action_line_audit_rec.audit_attribute := p_staffing_priority_code;
1684: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1685: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1686: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1687:
1688: ELSE
1689:
1690: -- ERROR: Insert error into the audit table

Line 1703: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1699:
1700: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
1701: l_action_line_audit_rec.action_code := p_action_code;
1702: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
1703: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1704: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1705: END IF; -- IF p_insert_audit_flag = 'T'
1706: x_return_status := FND_API.G_RET_STS_ERROR;
1707: END IF; -- IF FND_MSG_PUB.Count_Msg > 0

Line 1704: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1700: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
1701: l_action_line_audit_rec.action_code := p_action_code;
1702: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
1703: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1704: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1705: END IF; -- IF p_insert_audit_flag = 'T'
1706: x_return_status := FND_API.G_RET_STS_ERROR;
1707: END IF; -- IF FND_MSG_PUB.Count_Msg > 0
1708:

Line 1732: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1728: l_action_line_audit_rec.action_code := p_action_code;
1729: l_action_line_audit_rec.audit_display_attribute := l_update_sp_display_attribute;
1730: l_action_line_audit_rec.audit_attribute := p_staffing_priority_code;
1731: l_action_line_audit_rec.reversed_action_set_line_id := p_action_set_line_id;
1732: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1733: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1734:
1735: END IF;
1736:

Line 1733: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1729: l_action_line_audit_rec.audit_display_attribute := l_update_sp_display_attribute;
1730: l_action_line_audit_rec.audit_attribute := p_staffing_priority_code;
1731: l_action_line_audit_rec.reversed_action_set_line_id := p_action_set_line_id;
1732: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1733: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1734:
1735: END IF;
1736:
1737: END IF; -- action status

Line 1869: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1865: l_action_line_audit_rec.action_code := p_action_code;
1866: l_action_line_audit_rec.audit_display_attribute := null;
1867: l_action_line_audit_rec.audit_attribute := null;
1868: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1869: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1870: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1871:
1872: END IF;
1873:

Line 1870: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1866: l_action_line_audit_rec.audit_display_attribute := null;
1867: l_action_line_audit_rec.audit_attribute := null;
1868: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
1869: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1870: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1871:
1872: END IF;
1873:
1874: -- get all the currently active audit lines

Line 1968: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

1964: l_action_line_audit_rec.action_code := p_action_code;
1965: l_action_line_audit_rec.audit_display_attribute := l_remove_adv_display_attribute;
1966: l_action_line_audit_rec.audit_attribute := null;
1967: l_action_line_audit_rec.reversed_action_set_line_id := p_action_set_line_id;
1968: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1969: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1970:
1971: END IF;
1972:

Line 1969: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

1965: l_action_line_audit_rec.audit_display_attribute := l_remove_adv_display_attribute;
1966: l_action_line_audit_rec.audit_attribute := null;
1967: l_action_line_audit_rec.reversed_action_set_line_id := p_action_set_line_id;
1968: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1969: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1970:
1971: END IF;
1972:
1973: IF l_action_set_line_id_tbl.COUNT > 0 THEN

Line 2206: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

2202: ELSE
2203: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
2204: END IF;
2205:
2206: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
2207: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
2208:
2209: ELSIF p_insert_audit_flag = 'T' AND l_perform_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2210:

Line 2207: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

2203: l_action_line_audit_rec.reversed_action_set_line_id := NULL;
2204: END IF;
2205:
2206: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
2207: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
2208:
2209: ELSIF p_insert_audit_flag = 'T' AND l_perform_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2210:
2211: FND_MSG_PUB.get (

Line 2223: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;

2219: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
2220: IF l_action_status_code = 'REVERSE_PENDING' THEN
2221: l_action_line_audit_rec.reversed_action_set_line_id := l_action_set_line_id_tbl(i);
2222: END IF;
2223: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
2224: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
2225:
2226: END IF; -- if p_insert_audit_flag = 'T'
2227:

Line 2224: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;

2220: IF l_action_status_code = 'REVERSE_PENDING' THEN
2221: l_action_line_audit_rec.reversed_action_set_line_id := l_action_set_line_id_tbl(i);
2222: END IF;
2223: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
2224: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
2225:
2226: END IF; -- if p_insert_audit_flag = 'T'
2227:
2228: END LOOP;